Find lowest value in a range

P

Pat

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
(e-mail address removed)
 
B

Bob Phillips

Pat,

Try

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

--

HTH

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

Bernd Plumhoff

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

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

HTH,
Bernd
 
H

Harlan Grove

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

Everyone else likes LARGE or SMALL. I'd use simpler tools.

=(SUM(Range)-MIN(Range))/3
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to find additional ranges outside of min, max, and average 2
Trying to subtract the two lowest values from a row of numbers 4
Find the lowest value in a row 2
lowest number in a set EXCLUDING zero 2
Find the lowest4 numbers of the last 6 in a range 4
Find lowest total of cells in range without sorting 5
Return the 2 lowest numbers within a range 6
find two (2) lowest values in a range (Excel) 3

Top