Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to find a different value within a List
If cell A1 = $13.20
In cell A2 = I want to find the value above $13.20 in the list below: (ANSWER: $14.40) Cell C1 = $16.00 Cell C2 = $15.20 Cell C3 = $14.40 Cell C4 = $13.20 Cell C5 = $12.00 Cell C6 = $10.40 .... Where as: The cell values may change and have no correlation between each other. The value in C1 Will always equal one of the options from the list. Thanks, Dustin |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to find a different value within a List
Try,
=LARGE(C1:C6, RANK(A1,C1:C6)-1) Mike "dj479794" wrote: If cell A1 = $13.20 In cell A2 = I want to find the value above $13.20 in the list below: (ANSWER: $14.40) Cell C1 = $16.00 Cell C2 = $15.20 Cell C3 = $14.40 Cell C4 = $13.20 Cell C5 = $12.00 Cell C6 = $10.40 ... Where as: The cell values may change and have no correlation between each other. The value in C1 Will always equal one of the options from the list. Thanks, Dustin |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to find a different value within a List
Yes. It worked! Thankyou! Never used "LARGE" before. I like it.
"Mike H" wrote: Try, =LARGE(C1:C6, RANK(A1,C1:C6)-1) Mike "dj479794" wrote: If cell A1 = $13.20 In cell A2 = I want to find the value above $13.20 in the list below: (ANSWER: $14.40) Cell C1 = $16.00 Cell C2 = $15.20 Cell C3 = $14.40 Cell C4 = $13.20 Cell C5 = $12.00 Cell C6 = $10.40 ... Where as: The cell values may change and have no correlation between each other. The value in C1 Will always equal one of the options from the list. Thanks, Dustin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i find any value in a list that is not #NA | Excel Worksheet Functions | |||
How to find a find a list of possible inputs to sum a known amt? | Excel Discussion (Misc queries) | |||
list 1 has 400 names List 2 has 4000. find manes from list 1 on 2 | Excel Worksheet Functions | |||
Find in a list | Excel Discussion (Misc queries) | |||
find names on list 1 in list 2. list 1 4000 names list 2 400 name | Excel Worksheet Functions |