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.
--------------------------------------------
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
No comments:
Post a Comment