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     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

No comments:

Post a Comment