Skip - your solution worked PERFECTLY !!!!!! Thanks
follow-up question - if trying to exclude the lowest (min) number ....I changed the "max" in the formula to "min" but did not get the correct answer. What must I do in order to modify your formula to exclude the lowest number within the data...
Trying to create a formula that will give me an average number from a list of numbers in excel, but I want the formula to exclude the highest number within the data range before giving me the average.
Note - the highest number could be anywhere within the data range.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.