I can tell you the reason you are using it,
it's because it is independent of row insertions above the formula,
so it is more stable

Frank's formula will return wrong result if you insert a row above the
formula
--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)



"Myrna Larson" wrote in message
...
But instead of ROW()-ROW($D$2)+1, which is dependent on the address of the
cell with the formula, use Frank's formula where he just writes ROW(1:!)

I don't know why, but I always forget about that!



On Fri, 29 Oct 2004 14:30:03 -0700, "JBoulton"
wrote:

Myrna and Frank,

FANTASTIC! Thanks for the lesson.

"Myrna Larson" wrote:


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