Show Top 10 with array formula
 

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

Show Top 10 with array formula
 

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

"Jen" wrote:

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