ExcelBanter - lookup and return multiple values

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - lookup and return multiple values (https://www.excelbanter.com/excel-discussion-misc-queries/139987-lookup-return-multiple-values.html)

Aaron

lookup and return multiple values

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

ufo_pilot

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

Roger Govier

lookup and return multiple values

Hi

FYI, you can just use the one formula copied down

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

--
Regards

Roger Govier

"ufo_pilot" wrote in message
...
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

All times are GMT +1. The time now is 12:15 PM.