Home |
Search |
Today's Posts |
#1
|
|||
|
|||
finding the second largest number in a list
Is there a way of finding the "second largest" number from
a list of 10 numbers ? I know MAX finds the biggest number but unsure if numbers of a particular rank in a list can be identified. Thanks |
#2
|
|||
|
|||
usef <large function
=large(array,k) i.e kth largestumber see help for <large similarly <small bobf wrote in message ... Is there a way of finding the "second largest" number from a list of 10 numbers ? I know MAX finds the biggest number but unsure if numbers of a particular rank in a list can be identified. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel formula divide list of #s by N to get a number above 40 | Excel Discussion (Misc queries) | |||
How do I pick a number from a list in Excel? | Excel Worksheet Functions | |||
How do I sum 4 number discarding the largest number. | Excel Worksheet Functions | |||
Lookup closest number in list | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |