Need help with averaging an excel report populated with dates andnames.

  • Thread starter Thread starter tsorvillo
  • Start date Start date
T

tsorvillo

I am working on trying to average data on an employee report(175
employees and 18 courses). The report list the employee name and if
they took the computer course it populates a cell with the date
completed. If the course was not taken it leaves the field blank. I
need to know the % of courses completed for each employee and the %
total completed for all employees. This report can be ran daily so I
need something easy to transfer. I am effluent in vb and access but
can't figure out the best way to program this. Thank you for any help
in advance.

Ex)

Column1(Name) Column 2(Course Name)
Employee name Date of completion
 
You seem to have two columns only (i.e. employee names listed repeatedly for
each course completed) and want a tally of completed courses/courses
available, expressed a percentage.

1) At the bottom of Employee name list (or elsewhere), create a unique list
of employee names.
2) Adjacent the name list, create a countif() formula
http://www.techonthenet.com/excel/formulas/countif.php
3) In column 3 simple mathematic dividing the count by the total courses and
formatting as a percentage should give you what you need.

Have you considered a pivot table?
http://www.contextures.com/xlPivot10.html
 
Back
Top