F
FUNACH
NEED TO AVERAGE A ROW OF NUMBERS PICKING OUT LOWEST 6?
Install the app
How to install the app on iOS
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
H
HelpExcel.com
You can use a formulaic array similar to the following:
=AVERAGE(IF(RANK(A1:A10,A1:A10)>4,A1:A10,""))
Make certain you replace A1:A10 with the range of numbers you want to
average and press cntrl-shift-enter
=AVERAGE(IF(RANK(A1:A10,A1:A10)>4,A1:A10,""))
Make certain you replace A1:A10 with the range of numbers you want to
average and press cntrl-shift-enter
H
HelpExcel.com
You can use a formulaic array similar to the following:
=AVERAGE(IF(RANK(A1:A10,A1:A10)>4,A1:A10,""))
Make certain you replace A1:A10 with the range of numbers you want to
average and press cntrl-shift-enter
=AVERAGE(IF(RANK(A1:A10,A1:A10)>4,A1:A10,""))
Make certain you replace A1:A10 with the range of numbers you want to
average and press cntrl-shift-enter
T
T. Valko
Try this:
=AVERAGE(SMALL(A1:A10,{1,2,3,4,5,6}))
=AVERAGE(SMALL(A1:A10,{1,2,3,4,5,6}))
T
T. Valko
Try this:
=AVERAGE(SMALL(A1:A10,{1,2,3,4,5,6}))
=AVERAGE(SMALL(A1:A10,{1,2,3,4,5,6}))
J
Jacob Skaria
Refer your other post.. Please dont multi-post . Also avoid using caps in
subject....
subject....
J
Jacob Skaria
Refer your other post.. Please dont multi-post . Also avoid using caps in
subject....
subject....
P
Paul C
If you only have 10 items use the Large function to subtract the 4 largest
Exapmle data in cells A3:J3
=(SUM(A3:J3)-LARGE(A3:J3,1)-LARGE(A3:J3,2)-LARGE(A3:J3,3)-LARGE(A3:J3,4))/6
if the number of cells floats use the Small function to get the six smallest
=(SMALL(A3:J3,1)+SMALL(A3:J3,2)+SMALL(A3:J3,3)+SMALL(A3:J3,4)+SMALL(A3:J3,5)+SMALL(A3:J3,6))/6
Exapmle data in cells A3:J3
=(SUM(A3:J3)-LARGE(A3:J3,1)-LARGE(A3:J3,2)-LARGE(A3:J3,3)-LARGE(A3:J3,4))/6
if the number of cells floats use the Small function to get the six smallest
=(SMALL(A3:J3,1)+SMALL(A3:J3,2)+SMALL(A3:J3,3)+SMALL(A3:J3,4)+SMALL(A3:J3,5)+SMALL(A3:J3,6))/6
P
Paul C
If you only have 10 items use the Large function to subtract the 4 largest
Exapmle data in cells A3:J3
=(SUM(A3:J3)-LARGE(A3:J3,1)-LARGE(A3:J3,2)-LARGE(A3:J3,3)-LARGE(A3:J3,4))/6
if the number of cells floats use the Small function to get the six smallest
=(SMALL(A3:J3,1)+SMALL(A3:J3,2)+SMALL(A3:J3,3)+SMALL(A3:J3,4)+SMALL(A3:J3,5)+SMALL(A3:J3,6))/6
Exapmle data in cells A3:J3
=(SUM(A3:J3)-LARGE(A3:J3,1)-LARGE(A3:J3,2)-LARGE(A3:J3,3)-LARGE(A3:J3,4))/6
if the number of cells floats use the Small function to get the six smallest
=(SMALL(A3:J3,1)+SMALL(A3:J3,2)+SMALL(A3:J3,3)+SMALL(A3:J3,4)+SMALL(A3:J3,5)+SMALL(A3:J3,6))/6
R
Robert McCurdy
Array entered: ctrl + shift + enter
=AVERAGE(SMALL(A2:A11,ROW($1:$6)))
Regards
Robert McCurdy
=AVERAGE(SMALL(A2:A11,ROW($1:$6)))
Regards
Robert McCurdy
R
Robert McCurdy
Array entered: ctrl + shift + enter
=AVERAGE(SMALL(A2:A11,ROW($1:$6)))
Regards
Robert McCurdy
=AVERAGE(SMALL(A2:A11,ROW($1:$6)))
Regards
Robert McCurdy
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.