Hi in E12 enter the following formula
=INDEX($A$1:$A$100,MATCH(LARGE($B$1:$B$100,ROW(1:1 )),$B$1:$B$100,0))
and copy this down

Note: Does not work if you have ties in your list


--
Regards
Frank Kabel
Frankfurt, Germany


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