Sorry if my topic is confusing but I am confused myself.
What i have is a list of names and hours worked in 2 cols.
Col1.................Col2
John .................8
Peter ................5
John ................2
Jake ................1
John ................4
Jake ................10
What I want to be able to do is on another sheet, get it to
automatically grab the first name on the list and total all hours in
that list for that employee. I dont care if it has to be
alphabetically sorted etc. The go down the list and gra the next name
and total hours. Becasue of the way I have done my list the employee
names and hours could be anywhere up and down the list.
The result would be something like:
John 14
Peter 5
Jake 11
I imagine I would have quite a few lines of names and hours as we
operate 24/7 with 3 shifts and around 30 employees who may make work
muliple shifts.
Any help would be greatly appreciated.
Thanks
Dwayne
--
Dwayne
------------------------------------------------------------------------
Dwayne's Profile:
http://www.excelforum.com/member.php...fo&userid=5484
View this thread:
http://www.excelforum.com/showthread...hreadid=502681