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
No comments:
Post a Comment