| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to determine the value - 8 Dec?
Does anyone have any suggestions on how to determine the value?
There are two lists of number under column A and B. Example 1: I would like to determine the closest and minimum numbers between A and B A B 173 173 160 162 156 156 150 152 It should return 156 in cell C1 Example 2: I would like to determine the closest and maximum numbers between A and B A B 144 144 133 138 130 134 126 126 It should return 144 in cell C1 Does anyone have any suggestions on how to do it? Thanks in advance for any suggestions Eric |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to determine the max. value? | Excel Worksheet Functions | |||
| How to determine the max. value? | Excel Worksheet Functions | |||
| How to determine the value? | Excel Discussion (Misc queries) | |||
| How to determine the value? | Excel Worksheet Functions | |||
| How to Determine 1st, 2nd & 3rd for a PWD | Excel Discussion (Misc queries) | |||
Threaded Mode
