Tuesday, August 2, 2011

yogi_Filter A Number Of Rows Based On Uniqueness Of A Single Column

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com

santosh2 said:
Filter a number of rows based on uniqueness of a single column
I am using Google Forms to populate a Google Spreadsheet for use as a database. One item of data is used as an index for each entry/record. I would like to be able to filter the database to include only the most recent submission of data for all indices.
I.e. if the index is a record number, users may enter data for the following record numbers in this order: 1,2,3,4,3,1. I would like to extract from this database the most recent versions of 1,2,3, and 4. The second entries for records 3 and 1 would effectively overwrite the earlier entries.
The responses are logged in a sheet named Form and the filtered records are shown in Sheet1