Assuming codes in A2:A100, Value1 in B2:B100, the first formula in D2
=INDEX($A$2:$A$100,MATCH(LARGE($B$2:$B$100,ROW()-ROW($D$2)+1),$B$2:$B$100,0))
and copy down for 25 rows.
If you put the first formula in a cell other than D2, you must change the $D$2
to refer to that cell with the 1st formula.
On Fri, 29 Oct 2004 13:51:01 -0700, "JBoulton"
wrote:
Hi, all.
My data looks like this:
Code Value1 Value2
1 100 1000
2 125 999
3 110 25
How can I list the codes for the 25 largest numbers in Value1? The data
changes constantly.
TIA
|