| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average formula
Is there a manipulation to the "average" function that allows a user to take
the average of a set of data and exclude the maximum and minimum value of the entire set? I am using a LARGE set of data and I do not want to have to sort data from min to max ,if I can avoid it. Thanks for the help. If such a manipulation in Excel is available, does it work for other functions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| A formula to AVERAGE IF but only average a set number of values | Excel Worksheet Functions | |||
| Average formula | Excel Discussion (Misc queries) | |||
| Average Row Formula | Excel Discussion (Misc queries) | |||
| how does one convert text to a formula "average(A:A)" to =average( | Excel Worksheet Functions | |||
| Average Formula | Excel Worksheet Functions | |||
Threaded Mode
