lookup and return multiple values

[Guest]

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?

 

[Guest]

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

 

[Roger Govier]

Hi

FYI, you can just use the one formula copied down

=LARGE($A$1:$A$25,ROW(A1))