Thread
:
Find lowest value in a range
View Single Post
#
2
JE McGimpsey
Posts: n/a
One way:
=AVERAGE(LARGE(A1:A4,{1,2,3}))
In article ,
"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.
Reply With Quote