View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
ufo_pilot ufo_pilot is offline
external usenet poster
 
Posts: 142
Default 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