lookup and return multiple values
If your column of 25 cells starts in A1, then in B1 put the formula:
=LARGE(A:A,1)
B2 put
=LARGE(A:A,2)
B3 put
=LARGE(A:A,3)
B4 put
=LARGE(A:A,4) etc until you have your 15 cells
HTH
"Aaron" wrote:
Hello,
I would like to be able to lookup from a collumn containing 25 values
(cells) and return the highest 15 values in the cells below it?
--
Cheers
Aaron
|