Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting Max 20 Numbers
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 !!! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting Max 20 Numbers
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 "Irfan Khan" wrote: 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 !!! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting Max 20 Numbers
=LARGE(A:A,ROW(1:1))
and Copy down 19 rows. "Irfan Khan" wrote: 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 !!! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting Max 20 Numbers
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 "Irfan Khan" wrote: 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 !!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selecting last five numbers in a selection | Excel Discussion (Misc queries) | |||
Selecting specific numbers from a cell containing multiple numbers | Excel Worksheet Functions | |||
selecting the two lowest numbers | Excel Discussion (Misc queries) | |||
Selecting columns with column numbers not letters | Excel Programming | |||
selecting checkbox numbers | Excel Programming |