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