Home |
Search |
Today's Posts |
#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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |