WinXP/Excel 2002

Need to locate and discard lowest value out of 4 numbers. Remaining three
numbers to be averaged - with that number being used later on.

Tried DMIN - but had trouble with formula set-up.

Any advice?

Thank you

PatJoram

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.

Pat,

Try

=AVERAGE(LARGE(N1:N4,{1,2,3}))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Pat" wrote in message
...
WinXP/Excel 2002

Need to locate and discard lowest value out of 4 numbers. Remaining three
numbers to be averaged - with that number being used later on.

Tried DMIN - but had trouble with formula set-up.

Any advice?

Thank you

PatJoram

=SUM(LARGE(A1:A4,ROW(1:3)))/3

Enter with CTRL+SHIFT+ENTER (as array formula)

HTH,
Bernd

"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