Working out of Statistics on Exam Results URGENT solution needed!

[shaneallen16]

http://www.box.net/shared/q6id1k3plhn3avp7q6gt

http://www.box.net/shared/q6id1k3plhn3avp7q6gt

http://www.box.net/shared/q6id1k3plhn3avp7q6gt


HI

Please check this link ,there are TWO files, one is Grade 8 (http://www.box.net/shared/et0q8my9qpvjefeciryx) and one is Grade 9, The Grade 9 files works out the STATS and returns it to a sheet called STATS. I want the Grade 8 sheet to do the same. to work out all the stats i.e. the number of codes per learning area

shaneallen16

[Excel Fox]

Shane, for Grad 8, from which sheet do you want to work out the STATS data? From Schedule sheet?

[shaneallen16]

Yes,that is correct - in the schedule sheet all the codes per subject/learning area is given for each learner/pupil. I would be so grateful if you can assist

[shaneallen16]

Hi check out the Grade 9 sheet which is available via a link in my post . Each teacher take a copy of the sheet and only complete his marks and then all is imported into one sheet from their flashdrives or wherever they have stored the sheet.

[shaneallen16]

http://www.box.net/shared/q6id1k3plhn3avp7q6gt/1/122013897/969991807

Grade 8 file link

[shaneallen16]

If anyone has solution please email as I am at shaneallen16@gmail.com as I have my email on whole day

Shane

[shaneallen16]

Hi

I was posted a suggestion to copy all classes to a new sheet but is there an automated way to do it?

[shaneallen16]

HI Guys I just wish I knew how to see the functions of the Grade 9 file maybe that can help me with the grade 8 file

[shaneallen16]

Hi can someone write me a macro which can return the total number of codes per subject per term

[shaneallen16]

Hi Guys I am still looking for a solution, wish someone can help me

[shaneallen16]

If someone can give me the password for the grade 9 file maybe I can copy those formulas, please guys if someone can help I am in desperate need for a solution. I just wish to do it manualy

[shaneallen16]

:confused::(Hi guys I feel so despondent as it seems nobody understands what I want or it looks like nobody knows what I want. Another exam is coming up and I hate to do it manually again to get the stats

[Excel Fox]

What you need is to have the same automatic calculation happening for Grade 9, to be done for Grade 8 also. But you do not have the password for the Grade 9 file. Correct?