Thursday, December 8, 2011

yogi_Pull Latest Submitted Data By Name

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com
user MF-Elm said:
Delete duplicate rows based on data in one column and checked against a timestamp
Is there a way to check duplicate entries in one column (column B) and then depending on the timestamp found in column A, delete the rows for older duplicate entries, leaving only the most current timestamped entry?
I'm using a form to input data into the spreadsheet currently, but I don't believe there's no way to update the information as it changes through the form without it creating a second entry in the spreadsheet.

--------------------------------------------
following is a solution to the problem