| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Averaging without the highest or lowest values
On Nov 1, 10:29 am, leadfoot
wrote: I've tried Excel help and played around with formulas, and I can't find anything for what should be a pretty simple issue: I want to calculate averages on a series of values for each month, while discarding the highest and lowest values. Perhaps I just didn't word it right when using Excel help, but no results were helpful ... Thanks! Try... =TRIMMEAN(Range,2/COUNT(Range)) Hope this helps! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Difference Between Highest And Lowest? | Excel Discussion (Misc queries) | |||
| Average of values in row excluding the highest and lowest value? | Excel Worksheet Functions | |||
| Formula to higlight highest and lowest values in row | Excel Worksheet Functions | |||
| Graph Highest to Lowest. | Excel Discussion (Misc queries) | |||
| Highest High and Lowest Low | Excel Discussion (Misc queries) | |||
Threaded Mode
