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.
Note - the highest number could be anywhere within the data range.