Devise a simple Excel summary of the marks a list of referee's get per game at football
4771
£75(approx. $96)
- Posted:
- Proposals: 4
- Remote
- #97594
- Archived
Description
Experience Level: Intermediate
I have a list of names of people, for each instance of the name I have a mark between 0 & 100 (Football Referee's), I need all of these instances to be calculated into an average per person.
I want to be able to extend the list every week month as more marks are received and to then give a new average and the number of instances the person has referereed. I nee some kind of macro that I can just extend the list and recalculate - new names could be added, so some kind of name recognition look up, that calculates the average against that name, and the count of the number of marks received
Output should look like
Name Average No of marks
John Smith 72 15
I have attached the list I have so far
I want to be able to extend the list every week month as more marks are received and to then give a new average and the number of instances the person has referereed. I nee some kind of macro that I can just extend the list and recalculate - new names could be added, so some kind of name recognition look up, that calculates the average against that name, and the count of the number of marks received
Output should look like
Name Average No of marks
John Smith 72 15
I have attached the list I have so far
Graham E.
0% (0)Projects Completed
1
Freelancers worked with
1
Projects awarded
100%
Last project
20 Oct 2011
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies