Selecting Max 20 Numbers

[Irfan Khan]

Hi Experts !!!


I need to select some top 20 numbers out of some thousand from a particular
column only. Can somebody please help me to give a hint for the code.

Thanks a Lot !!!

 

[Mike H]

Hi,

You probably won't have to select these numbers to work on them, what do you
want to do with the largest 20 numbers?

Mike

 

[JMay]

=LARGE(A:A,ROW(1:1))
and Copy down 19 rows.

 

[PJFry]

How are you defining 'top 20'? If you have a list of values where you can
rank them, you can apply a rank function:
=RANK(A1,$A$1:$A$5000), where A1 is the value to be ranked and $A$1:$A$5000
is the range that holds all of the values. This will give a numeric rank for
the values. Copy the formula down the range of values. Once you have that,
just sort descending on the column and the top 20 come to the top.

To Mike's point, what you want to do with these is important. If it is just
to know the top 20 by some criteria, like total dollars or total units sold,
then the rank should work. If you want to do something else, write back with
more details.

PJ