Consolidating Rows based on multiple matching criteria

[niallmurph]

HiMr Excel,

Iam hoping you can help me aggregate some figures on a sheet of audit data.

Basically, I need to consolidate any rows with matching entries in Columns A , C, and H.

i.e.if Row 3 contains…

[TABLE="width: 1"]
<tbody>[TR]
[TD] IE2_IC1.1
[/TD]
[TD]

45​

[/TD]
[TD] IE2_1A01
[/TD]
[TD]

16​

[/TD]
[TD]

24​

[/TD]
[TD]

8​

[/TD]
[TD] 34%
[/TD]
[TD] CAT
[/TD]
[/TR]
</tbody>[/TABLE]


AndRow 5 contains…

[TABLE="width: 1"]
<tbody>[TR]
[TD] IE2_IC1.1
[/TD]
[TD]

42​

[/TD]
[TD] IE2_1A01
[/TD]
[TD]

8​

[/TD]
[TD]

12​

[/TD]
[TD]

4​

[/TD]
[TD] 34%
[/TD]
[TD] CAT
[/TD]
[TD]
[/TD]
[/TR]
</tbody>[/TABLE]


AndRow 9 contains…

[TABLE="width: 1"]
<tbody>[TR]
[TD] IE2_IC1.1
[/TD]
[TD]

12​

[/TD]
[TD] IE2_1A01
[/TD]
[TD]

8​

[/TD]
[TD]

12​

[/TD]
[TD]

4​

[/TD]
[TD] 34%
[/TD]
[TD] CAT
[/TD]
[TD]
[/TD]
[/TR]
</tbody>[/TABLE]



ThenI'd like to consolidate those rows into a single aggregated row.

Isthis something can be explained easily?

Any help appreciated!