Formula to find average of 3 highest entries in a row?

T

TR

Suppose A1:K1 contain numbers. I want the mean of the 3 highest numbers
in the range. Is there a way to get a formula to do that? If not, VBA?

Thanks in advance.
 
J

JE McGimpsey

TR said:
Suppose A1:K1 contain numbers. I want the mean of the 3 highest numbers
in the range. Is there a way to get a formula to do that? If not, VBA?
Click to expand...

One way:

=AVERAGE(LARGE(A1:K1,{1,2,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
Copy addition formula of non-consecutive horizontal cells 2
Index/Match Functions to Return Concatenated Response 4
Conditional format question 4
Findiing highest and lowest in rows and columns 3
Finding location (or start cell) of highest consecutive values 3
location of highest consecutive values 0
WORD VBA Search and switch to advanced ... 1

Top