Conditional Consolidate

[Drmwvr7266]

I have the basic understanding of consolidating down. I have similar names in column A that consolidate the hours in column B.

Now, can I throw in a twist? Column A has a name. Column B has a code. Column C has the hours.

Did some reading up on it but not sure if I can do this. Basically, If column A and column B match, then they consolidate. Otherwise, they don't.

Name Code Hrs.
Bob Code 1 5
Bob Code 2 5
Bob Code 1 3
Mike Code 1 4
Mike Code 2 7


The result would be:

Bob Code 1 8
Bob Code 2 5
Mike Code 1 4
Mike Code 2 7


Any suggestions? I am adding it into some code that I have been developing over time to reduce payroll prep time on Monday Mornings.

 

[Mark W.]

Use a PivotTable...

Date_example.xls
	A	B	C	D	E	F	G	H	I	J	K
1	Name	Code	Hrs.		SumofHrs.
2	Bob	Code1	5		Name	Code	Total
3	Bob	Code2	5		Bob	Code1	8
4	Bob	Code1	3			Code2	5
5	Mike	Code1	4		Mike	Code1	4
6	Mike	Code2	7			Code2	7
7
Sheet2