Finding the average from two sets of data

Closed
Andrew - Aug 18, 2010 at 07:16 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Aug 18, 2010 at 07:40 AM
Hello,
Hi,
Can someone PLEASE assist me?
I have over 3000 rows and I need to find the average, for the overall mark, and match it to the Genre, type of test. I have to find out which Genre type eg (Letter) has the highest marks and what is the average. also which types are the lowest. there are over 20 Genre Types. the other marks are not needed only Overall mark and Genre.
Thanks for all the help
Andrew

Overall Mark CI Voc Resp GSP S&S Length Genre Chosen
5+ 5 3- 5 3- 3- Far too short' Letter

1 reply

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Aug 18, 2010 at 07:40 AM
Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc
A N D post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too
1