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     www.energyefficientbuild.com.   May 04, 2013
user Tony503 (http://productforums.google.com/forum/?zx=f30enu3qruz8#!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