How do I drop the lowest 2 numbers and then average?

N

N Harkawat

=AVERAGE(SMALL(A:A,ROW(INDIRECT("1:"&COUNTA(A:A)-2))))
Array entered (ctrl+shift+enter)
 
N

N Harkawat

Sorry you needed to exclude the smallest 2 entries
Change "small" to "large" so correct formula will be
=AVERAGE(LARGE(A:A,ROW(INDIRECT("1:"&COUNTA(A:A)-2))))
Array entered (ctrl+shift+enter)
 

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
Need help with a formula 3
Extract the 2 Lowest % 3
Findiing highest and lowest in rows and columns 3
Paragraph numbering in Word 1
How to make repeating drop-down lists? 2
calculate last 4 data points in a column (with sometimes blank rows) 7
Average With < Continued 4

Top