Saturday, May 4, 2013

yogi_From A Table Of Names And Responses Pull A List Of Names With The Corresponding Latest Response

                                          Google Spreadsheet   Post  #1169
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   May 04, 2013
user Tony503 (!category-topic/docs/spreadsheets/gwPvv7CahyU)
How do you find the last match in a column?

I have 6 sets of data with duplicate names (people changing their mind). How do I find the last match? How do I get "No" for Tony and Chris?  Thanks!
       A           B
1  Chris      Yes
2  Tony      Yes
3  Mary       No
4  Jane       Yes
5  Tony       No
6  Chris      No

following is a solution to the problem