Google Spreadsheet Post #1105
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Apr 10, 2013
user Robert Warner and question by Allana Mayer:(http://productforums.google.com/forum/?zx=ik561dw2e7n8#!mydiscussions/docs/3cLYffOYn9Y)
Remove duplicate values and subsequent rows
I'm looking to do something similar: have older entries removed when a new record with an identical field in Column A is entered (in this case, username).
When a new record is added: take new entry in Column A and compare to the rest of Column A for repeat values.
If a repeat value exists, delete earlier record.
If no repeat value exists, do nothing.
That's all.
----------------------------------------------------------------------------------------------------------------
the solution presented herein is similar in approach to the solution presented in the following blog post:
yogi_In A Table of names And Addresses Pull Only The First Instance of A Name And The Associated Address
in the above mentioned post, I pull only the first instance of a name and the associated address ...
and
in the following solution I pull only the last instance of a name and the associated address ... so here we go
