drop lowest number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

how do i drop the lowest number and average all of them except the lowest
 
Hi Val
Try the following entered as an array (Shift-Ctrl-Enter)
=AVERAGE(IF(A1:A5<>MIN(A1:A5),A1:A5))
 
Need to be careful there - what happens with 4 3 2 1 1

It will lose two of the values and not just *the* lowest number as there is more
than one. Now this may well be what the OP wants but the question needs to be
clarified really.
 
Val,
FYI I should explain the difference between Ken's response and mine, so that
you are aware. Should you use the array formula that I gave you, it will
automatically eliminate all of the minimums. For example if you have
1
1
3
4
5

The array formula will give you an average of 4, where as the formula Ken
gave would give an average of 3.25
The Array formula considers the event of a tie, and throws out both 1's
leaving you with 3, 4 and 5 and averages those.

Both are valid, just depends on what you're looking for
 
I agree Ken. I just posted the same message to Val so she would be awareof
that.
 
You must log in or register to reply here.

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

remove lowest 2 values in a row? 2
=average - eliminate the top and bottom number 5
Find the lowest number? 3
Formula for 6 lowest #'s in a range then average of them. 2
Subtracting Values from a Ranked List 4
Select low numbers from range + 6
Highlight the lowest number - only if it does not equal another va 6
Showing the top result from a range of cells 6

Back
Top