Saturday, March 2, 2013

yogi_Present in Ascending Order Only Those Names That Meet Specified Criteria (untainted names)



                                          Google Spreadsheet   Post  #1062
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Mar 2, 2013
user rajvivek:(http://productforums.google.com/forum/?zx=d9gpshy1lsr9#!mydiscussions/docs/p9EXHHjLnGo)
Sort & filter a column based on a criteria in another column
n a sheet, column A has names of people & column B has amount they have received till date. In column C i want the names in column A to be sorted alphabetically with the condition that only those names appear who have received amount more than 0 as indicated in column B.

I have created a mock sheet for easy understanding. 

I have used the formula =sort(unique(A2:A12)), which is obviously wrong since it is not taking any reference from column B.

Thanks!

Vivek
-----------------------------------------------------------------------------------------------------------

following is a solution to a bit more generalized problem