Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Anoth vbscript question ... sorry ! | Setting up and Configuration of Excel | |||
conditional formatting + VBscript | Excel Discussion (Misc queries) | |||
Report on upcoming dates | Excel Discussion (Misc queries) | |||
How do I get my dates in a report to export into my query? | Excel Discussion (Misc queries) | |||
pivot reports - limit report to last 20 dates | Excel Worksheet Functions |