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