I have 50 numbers in 50 cells ranging 0 to 100.
There are 5 0's and 7 100's, the rest of the numbers are the ones I want to find the average of.
Without sorting high to low what would the formula be to exclude these numbers?
Hope someone can help.
Thanks
Bookmarks