Need help with averaging an excel report populated with dates and names.

Giganews Newsgroups
Subject: Need help with averaging an excel report populated with dates and names.
Posted by:  tsorvil…@columbus.rr.com
Date: Tue, 8 Jul 2008

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

Replies