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
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 210 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 300 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!