Morning,
Any help would be greatly appreciated. I have attached the spread sheet to give some clairty.
In column O I have the total number of points a student has
In column P I have the average number of points a student got for each lesson
What I am trying to put in column Q is a formula that will work out the average score of the HIGHEST 8 subjects, rather than them all.
Thanks
Last edited by Cmorgan; 07-02-2012 at 05:35 AM.
Try this array formula
=AVERAGE(LARGE(B2:N2,ROW($1:$8)))
commit with Ctrl-Shift-Enter, not just Enter
Hi
In Q2,try this Array formula(Control+Shift+Enter)
=AVERAGE(LARGE(B2:N2,{1,2,3,4,5,6,7,8}))
Is this, works for you?
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Hi look into attachment
Regards
tom1977
If You are satisfied with my solution click the small star icon on the left to say thanks.
To avoid error if there is less than 8 numbers use:
=AVERAGE(LARGE($B2:$N2,ROW($A$1:INDEX($A$1:$A$100,MIN(8,COUNT($B2:$N2))))))
(ctrl+shift+enter)
Fotis
I am late a little with the same answerbut You do not need use E + C + S
Thanks guys, much appreciated.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks