View Single Post
  #2   Report Post  
JE McGimpsey
 
Posts: n/a
Default

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.