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

http://yogi--anand-consulting.blogspot.com/2013/04/yogiin-table-of-names-and-addresses.html

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