3 largest numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a column of numbers (eg 100 numbers) and I need to have the 3 largest
numbers in 3 different cells. The largest one can be done through the max
function. What about the other two? Please note that these numbers can be
different from time to time, therefore I need a clever way to do it.
Preferably, please show me a way without adding columns etc, using formulas
as much as possible. Thanx!
 
Use LARGE(array,1) for the largest, LARGE(array,2) for the second largest, etc.

If you dislike using functions, then sort the array descending and pull-off
the first three entries
 

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

Find values across a row and return a text value from the same column 2
Finding a folder with the largest number. 1
smallest to largest 9
ranking numbers in a column 7
Formula help 1
How can I select the largest number in a list... 1
removing a cell from an array 1
Add largest Values 2

Back
Top