| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Getting top 5 values in a list of numbers
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Getting top 5 values in a list of numbers
=LARGE(TheList,k)
k being any value from 1 to 5 for your purposes. -- Vasant "Roel" wrote in message ... Hi, I would like to know if there is a way to get the 5 largest values in a list of numbers. I know using MAX would only get the largest. I would like some rountine that would do it. Thanks very much! Roel |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple values from the same list of numbers | Excel Worksheet Functions | |||
| change a vertical list of numbers to horizontal list from 1 cell | Excel Discussion (Misc queries) | |||
| can numbers be assigned to values, replacing values for numbers | Excel Discussion (Misc queries) | |||
| how to extract unique numbers once from a list of repeated numbers? | Excel Discussion (Misc queries) | |||
| Min values in a list of numbers | Excel Worksheet Functions | |||
Linear Mode
