Finding the average from two sets of data

Closed
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
769
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