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

yogi_Compute Exactness Of Amount Computed (column C) And Amount Actually Written Out (column D)

                                          Google Spreadsheet   Post  #1052
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Feb 27, 2013
user rajvivek said:(http://productforums.google.com/forum/#!searchin/docs/rajvivek/docs/_RY-7Hw3120/HEBtK1CT4XQJ)
EXACT formua is not working expectadly in few of the cells...

I am trying to use a simple formula : =ARRAYFORMULA(EXACT(C3:C7, D3:D7)) but it seems to be not giving the expected result at few of the cells.

Please see this sheet. The cell E4 should be telling TRUE instead of FALSE. Please tell me both : WHY it is not giving the desired result, and HOW to fix it.

Thanks!

Vivek

-----------------------------------------------------------------------------------------------------------

the discrepancy is because of floating point arithmetic ... the numeric part of the entry in cell D8 is actually 17 characters long in contrast to 4748.1 apparently 6 characters long that it appears to be... so the following proposed solution