Thread
:
Find lowest value in a range
View Single Post
#
5
Harlan Grove
Posts: n/a
"Pat" wrote...
....
Need to locate and discard lowest value out of 4 numbers. Remaining three
numbers to be averaged - with that number being used later on.
....
Everyone else likes LARGE or SMALL. I'd use simpler tools.
=(SUM(Range)-MIN(Range))/3
Reply With Quote