ExcelBanter - Find lowest value in a range

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Find lowest value in a range (https://www.excelbanter.com/excel-worksheet-functions/7762-find-lowest-value-range.html)

Pat

Find lowest value in a range

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

JE McGimpsey

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.

Bob Phillips

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

Bernd Plumhoff

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

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

HTH,
Bernd

Harlan Grove

"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

All times are GMT +1. The time now is 11:25 PM.