Corrections, it should have read:
In C1: =IF(A1="","",A1-ROW()/10^10)
In D1: =INDEX(A:A,MATCH(LARGE($C:$C,ROWS($1:1)),$C:$C,0))
Copy D1 to E1. Select C1:E1, copy down to E5. Minimize col C. Cols D & E
returns the required auto-descending sort of cols A & B, by the values in col
A, with ties accounted for.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
---