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 |
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