Removing min, max & calculating average
Posted by Ron on December 06, 2001 4:59 PM
I have rows of numbers and need to remove only one min. and one max. and then calculate the average of the numbers that remain. The hitch is that the min/max could be anywhere in the row and some cells may be blank or have a zero.
All numbers will be between 0 and 9, but one row may have seven numbers while another may only have five or six.
One row could be 8 3 4 3 7 5 6
Another could be 4 2 9 5 6
If there is more than one min or max, only one can be removed.
Thank you for any help you can offer.