Show Top 10 with array formula

  • Thread starter Thread starter Jen
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Showing Top 30 with array-formula? 20
Formulas with-an an array 2
Cell Content via Secondary Formula 2
Excel Formula Range Limitation 7
Adding up with array formula 2
Array formula SUMIF with 2D sum_range array 3
Array formula: how to join 2 ranges together to form one array? 2
Showing Cummulative Top5 results with an array-formula...? 15

Back
Top