Hi,

Thanks for your help.


I tried the formulas but they return #N/A

The thing is that I have several postcodes in the spreadsheets, so the array should change. This is a sample of the dataset https://docs.google.com/spreadsheets...it?usp=sharing

By the way Joeu2004, I know that a trimmed mean doesn't remove outliers per se. The thing is that this dataset is about ambulance response times, and there were times when they didn't start counting (so the time value is 0) or that they didn't stop (so the time is too long). I thought that for this case the trimmed mean was useful. But if you know a better method, I'm more than happy to change!