| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average of values in row excluding the highest and lowest value?
What would be the best way to use the avg() function (or any other
appropriate function) on a column or row while excluding the highest and lowest value? is this possible in one cell, or does it have to be split up using min() and max() somewhere to exclude the value? Thanks, Robert |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to higlight highest and lowest values in row | Excel Worksheet Functions | |||
| average of highest 48 of 52 radom numbers with duplicate low #'s | Excel Worksheet Functions | |||
| Highest & lowest place value / decimal places of cell value | Excel Worksheet Functions | |||
| Highest High and Lowest Low | Excel Discussion (Misc queries) | |||
| Rank where lowest value is highest rank | Excel Worksheet Functions | |||
Threaded Mode
