Say your names are in Col 2, beginning row 2, and data in cols. B,C,D,E
Use the Data, Advanced Filter command to create a list of unique names in
Col. F
In G2, insert this fomula:
=SUMIF($F2,"="&A:A,B:B)
Copy across to cols H,I,J and down for as many rows as there are names in
Col. F
--
TedMi

"MAD101" wrote:

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 ANY NUMBER THAT IS IN THE SAME COLUMN ADD TO OTHER NUMBER 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
ADAMS, CLIFTON 13.00 12.50
ADAMS, CLIFTON 0 11.5
ADAMS, JAMES 12.33 11.50
ADAMS, JAMES 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 0 1
ADAMS, CLIFTON 13 12.50 0 1
ADAMS, JAMES 12.33 11.5 0 1

IF THERE IS A FORMULA THAT CAN DO THIS OR A MACRO, PLEASE HELP.