finding the second largest number in a list

  • Thread starter Thread starter bobf
  • Start date Start date
B

bobf

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