Wednesday, April 10, 2013

yogi_In A Table of names And Addresses Pull Only The Last Instance of A Name And The Associated Address


                                          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