View Single Post
  #5   Report Post  
Harlan Grove
 
Posts: n/a
Default

"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