| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| lookup and return multiple values | Excel Worksheet Functions | |||
| lookup 1 value and return multiple corresponding values | Excel Worksheet Functions | |||
| Lookup one value and return multiple corresponding values | Excel Discussion (Misc queries) | |||
| how to lookup a value and return multiple corresponding values | Excel Worksheet Functions | |||
| Lookup and return multiple Values | Excel Worksheet Functions | |||
Linear Mode
