Average a dataset after discarding the most extreme high and low values.
Copy this formula
=TRIMMEAN(A2:A100, 0.1)TRIMMEAN removes a percentage of data points from each end before averaging — 0.1 drops the top and bottom 5% combined. It's a robust average for data with a few extreme outliers.
=TRIMMEAN(Scores, 0.2)→74Average after trimming the extreme 20%.
TRIMMEAN splits the percent across both ends, so 0.1 removes 5% from the top and 5% from the bottom.
Need a formula for your own data?
Describe what you want in plain language and let ExcelGPT write, explain, and verify the formula — free to start, no plugin.