3 largest numbers
 

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!

3 largest numbers
 

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
--
Gary's Student


"Petros" wrote:

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!