Previous Topic Next Topic

Finding the average from two sets of data

Closed
Andrew - 18 Aug 2010 à 07:16
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 18 Aug 2010 à 07:40
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 response

Réponse 1 / 1
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
18 Aug 2010 à 07:40
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

Similar discussions

Hosted app data will not clear
Woody_3336 -
woody_3336 -

7 responses
How To Fix Mint Mobile Data Not Working?
sachin327 -
joshitha -

2 responses
Unlock safe folder without losing any data
Mintu -
HelpiOS -

1 response
Copying data from one Excel sheet to another.
Remedial -
Kav -

30 responses