Help w Excel combining duplicate rows and add

Closed
madi101 - Oct 12, 2008 at 09:10 PM
billakong Posts 19 Registration date Thursday September 4, 2008 Status Member Last seen June 10, 2009 - Oct 13, 2008 at 06:56 AM
Hello,
I have a spreadsheet with employee names and hours worked. Each employee has multiple lines with four columns. I want to have each employee have one line and to add the number of hours that is in the same column for that employee.

Name track track pp hrs
abrams, james 12.82 12.00
abrams, james 10.00 0 11.5
acker, edward 12.22 11.50
acker, edward 10.00 0 1


i can have hundreds of lines.

I want the outcome to look like this:

Name track track pp hrs
abrams, james 12.82 22.00 0 11.5
acker, edward 12.22 22.50 1 1

if there is a formula that can do this or a macro, please help.

1 reply

billakong Posts 19 Registration date Thursday September 4, 2008 Status Member Last seen June 10, 2009 5
Oct 13, 2008 at 06:56 AM
hey there,

here is alink which will be able to help you in what you are trying to do:

www.excelhelp.org
0