finding the second largest number in a list

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
 
R

R.VENKATARAMAN

usef <large> function

=large(array,k)
i.e kth largestumber
see help for <large>
similarly <small>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding a folder with the largest number. 1
How can I select the largest number in a list... 1
Find values across a row and return a text value from the same column 2
What is a formula for finding the largest date in a list of dates? 3
adding largest numbers 2
How to use large function? 3
removing a cell from an array 1
Largest Prime Number 9

Top