Calulating the number of days an employee works
I ned to no where employeenames are (ges there names are in several rows)?
and u ned to have the names somwhere only onse to calcuate with
"Curtis" skrev:
I currently use the following formula below to caculate the number of days
worked by each emloyee
=SUMPRODUCT(('Employee Data'!$L$5:$L$260<"")/COUNTIF('Employee
Data'!$L$5:$L$260,'Employee Data'!$L$5:$L$260&""))
However this formulae was used when each employee information was seperated
in seperate sheets.
I need to add a string to this fomrula that calcualtes the number of
different days worked by each employee (all employee information is now
compiled in a single sheet
Hopefully this make s sense
Thanks
ce
|