Show Top 10 with array formula

J

Jen

Hello there,

Would it be possible to evaluate A1:A2000 and show me the top 20 values in
B1:B20 ...with an array formula?

I think to have seen it the other day, but I cannot reproduce nor find it
....

Jen
 
M

Mike H

Jen,

What do you want an array for? Put this in B1 and drag down 20 rows for the
top 20 values.

=LARGE(A$1:A$2000,ROW())

Mike
 
Top