| Home |
| Search |
| Today's Posts |
|
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average of values in row excluding the highest and lowest value?
Try this:
With A1:I1 containing numbers This formula trims the high and low from the range and calcs the average J1: =TRIMMEAN(A1:I1,2/COUNT(A1:I1)) Is that something you can work with? *********** Regards, Ron XL2002, WinXP "frosterrj" wrote: 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
