Formula to remove smallest & largest # when doing an average calculation
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.
Answers
-
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.
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
Are you talking about the source sheet that I am basing cross sheet references on?
-
Yes please
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
Hi Bassam,
I have attached the source sheet. The formula referenced above takes from the FT Onsite time Column.
Thank you so much for offering your assistance.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!