Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup question
I have a large set of data with many entries. I need to find all instances of
any given value in the first column and then return the maximum and minimum corresponding value in the second column. For example: 110 25.3 111 6.3 113 7.5 110 11.2 112 21.3 113 11.8 114 30.1 110 2.7 In this example I would like to be able to specify a lookup value, 110 for example and then have a formula/formulae to retrieve the maximum and minimum value in the second column, 25.3 and 2.7 in this case. Thanks in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup question | Excel Worksheet Functions | |||
Question regarding lookup | Excel Discussion (Misc queries) | |||
Lookup question | Excel Worksheet Functions | |||
(V)LOOKUP question | Excel Worksheet Functions | |||
Lookup Question | Excel Worksheet Functions |