lookup and return multiple values

A

Aaron

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?
 
U

ufo_pilot

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
 
R

Roger Govier

Hi

FYI, you can just use the one formula copied down

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