Find the middle value, which ignores extreme outliers.
Copy this formula
=MEDIAN(A2:A100)MEDIAN returns the middle number of a range (the average of the two middle numbers if the count is even). It's a better center than AVERAGE when a few very large or small values would skew the mean.
=MEDIAN(Salaries)→62,000Typical salary, ignoring outliers.
Most frequent value
=MODE.SNGL(A2:A100)MODE returns the value that appears most.
When the data is skewed — incomes, house prices — the median better reflects the typical value.
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.