ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   finding the second largest number in a list (https://www.excelbanter.com/excel-discussion-misc-queries/13387-finding-second-largest-number-list.html)

bobf

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

R.VENKATARAMAN

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





All times are GMT +1. The time now is 12:19 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com