I would like to dev a formular that would drop the lowest number from a range of numbers, then average the remaining, rounding to next highest whole number. The outer range of each row will be the same but the quantity of data may differ, with some cells having zeros and some blank. Zeros should be included in the average but blanks ignored.
I started with =ROUND(AVERAGEA(B94:AC94),0)
can i drop the lowest number tacking on to this formular? any suggestions?
I started with =ROUND(AVERAGEA(B94:AC94),0)
can i drop the lowest number tacking on to this formular? any suggestions?