Sunday, April 14, 2013

yogi_Pull From data In Another Sheet Select Columns By Unique Last Names Only


                                          Google Spreadsheet   Post  #1126
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Apr 15, 2013
user morriscc  :(http://productforums.google.com/forum/?zx=j6jg3qrn27zo#!category-topic/docs/spreadsheets/R29hJW9km-I)
I need help selecting a unique name in a =QUERY

=QUERY( 'Sheet1'!A1:BT; "Select AA, E, D, I, C, F, G, H, J, L, M, N, P, Q, R, Y, Z WHERE E=ISAUNIQUENAME" ;0)  

E contains the same last name multiple times and I only want it to show up one time in my new sheet.

AA                      E              D      etc.........

ORDER LAST        FIRST
13/04/2013 Jones Jane
13/04/2013 Jones Jane
13/04/2013 Jones Jane
13/04/2013 Jones Jane
13/04/2013 Jones Jane
13/04/2013 Jones Jane
13/04/2013 Jones Jane
13/04/2013 Jones Jane
13/04/2013 Martin Mary
13/04/2013 Martin Mary

Thanks for any help!
------------------------------------------------------------------------------------------------------------------------
following is a solution to the problem