Excel AVERAGE questions.
August 5, 2009 12:38 PM Subscribe
Trying to get some modified AVERAGE results in Excel.
posted by FatherDagon to Computers & Internet (5 answers total) 1 user marked this as a favorite
Right now I've got a formula in my workbook 'AVERAGE(Data!Z:Z)', pooling turnaround time data from a single column on a different sheet. Most of the values are in the five minute range (3.5, 4.2, 7.1, 5.0, etc), however there are also very occasionally (say 5-10 cells in an array of 3000 or so) values that are closer to 1-2 days (1500 minutes, 2000 minutes, etc).
Is there a way to modify or append the AVERAGE function to either a) weed out values outside of a certain range, or b) get a median average that drops something like the 10 lowest and highest values in the range, or the bottom and top 1%, or something similar?