Here's a variation to the earlier play
to auto-extract the list in sorted descending order by x's col K
(just in case this is desired as well)
Assume source data is in sheet named: x,
data from row 2 down
where col B = Item, col K = Percent
In another sheet,
=IF(x!K2="","",IF(x!K210%,x!K2-ROW()/10^10,""))
Leave A1 blank
In B2:
=IF(ROWS($1:1)COUNT(A:A),"",INDEX(x!B:B,MATCH(LAR GE(A:A,ROWS($1:1)),A:A,0)))
In C2:
=IF(ROWS($1:1)COUNT(A:A),"",INDEX(x!K:K,MATCH(LAR GE(A:A,ROWS($1:1)),A:A,0)))
Format C2 as percentage. Select A2:C2, copy down to cover the max expected
extent of data in x, say down to C200. Minimize col A. Cols B & C will return
the descending-sort results, all neatly bunched at the top
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---