Formula to remove smallest & largest # when doing an average calculation

Sharon Castiglia

Hello,

I am currently trying to get an average of time and need to remove the outliers (i.e. -8.00 & 22.00). I currently have an average formula that includes those outliers:

=AVG([Shortest Fuel Vendor Install Time]@row, [Longest Fuel Vendor Install Time]@row)

As always, any assistance is greatly appreciated.

Bassam Khalil

Hi @Sharon Castiglia

Hope you are fine, Please add a copy of your sheet or a screenshot (after removing or replacing any sensitive information). This will make it easier for me to provide the appropriate answer to your question.

Sharon Castiglia

Are you talking about the source sheet that I am basing cross sheet references on?

Bassam Khalil

@Sharon Castiglia

Yes please

Sharon Castiglia

Hi Bassam,

I have attached the source sheet. The formula referenced above takes from the FT Onsite time Column.

Master Vendor Deployment Sheet (2).xlsx

Thank you so much for offering your assistance.