| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
averaging with conditions
A1 Height1 Height2 Height3 Height mean
B1 157.6 157.7 159 ? I need a formula that will average the two closest figures and ignore the third figure. eg Height 1 and Height 2 are closest therefore average these two but ignore Height 3. It won't always be that height 1 and 2 are are the closest. It could be that height 1 and 3 are closest or height 2 and 3 are closest. Help? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Averaging | Excel Discussion (Misc queries) | |||
| Averaging Cells Based On Conditions in Neighboring Cells | Excel Discussion (Misc queries) | |||
| Count using 2 conditions, one of which being a "less than or equal to" - URGENT | Excel Discussion (Misc queries) | |||
| Changing the range of several averaging functions | Excel Discussion (Misc queries) | |||
| Conditional Averaging - 2 Conditions | Excel Discussion (Misc queries) | |||
Threaded Mode
