| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
3 largest numbers
I have a column of numbers (eg 100 numbers) and I need to have the 3 largest
numbers in 3 different cells. The largest one can be done through the max function. What about the other two? Please note that these numbers can be different from time to time, therefore I need a clever way to do it. Preferably, please show me a way without adding columns etc, using formulas as much as possible. Thanx! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
3 largest numbers
Use LARGE(array,1) for the largest, LARGE(array,2) for the second largest, etc.
If you dislike using functions, then sort the array descending and pull-off the first three entries -- Gary's Student "Petros" wrote: I have a column of numbers (eg 100 numbers) and I need to have the 3 largest numbers in 3 different cells. The largest one can be done through the max function. What about the other two? Please note that these numbers can be different from time to time, therefore I need a clever way to do it. Preferably, please show me a way without adding columns etc, using formulas as much as possible. Thanx! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| return largest number of a list of numbers in the same cell | Excel Worksheet Functions | |||
| average of kth largest numbers in an array of n numbers | Excel Worksheet Functions | |||
| Count comma separated numbers, numbers in a range with dash, not t | Excel Discussion (Misc queries) | |||
| Checking Winning Numbers in the Lottery. | Excel Discussion (Misc queries) | |||
| Match Last Occurrence of two numbers and Return Date | Excel Worksheet Functions | |||
Linear Mode
