[Sephiroth]

Originally Posted by Hugh

Depends how large your sample size is - for instance, the ONS stats normally come from a sample size of around 180,000, but for the ast year it was 140,000 (due to COVID).

At both sample sizes you've given, TRIMMEAN would not be inapplicable. The real kicker in TRIMMEAN is the range of values at each extreme; the Excel formula allows you to snip at each extreme end.