I have a range with about 1000+ items.
Some of them have values of zero
Also, some of the values are very low or very high.
So, I need a formula to remove highest 1/3 of values and lowest 1/3 of NON-ZERO values and get average of the remaining. (Column H on the attached spreadsheet has some zero values. So, I want to have 120 values which are non-zeros. I need something likeFormula:Please Login or Register to view this content.
Bookmarks