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…

IE2_IC1.1

45​

IE2_1A01

16​

24​

8​

34%

CAT

<tbody>
</tbody>

AndRow 5 contains…

IE2_IC1.1

42​

IE2_1A01

8​

12​

4​

34%

CAT

<tbody>
</tbody>

AndRow 9 contains…

IE2_IC1.1

12​

IE2_1A01

8​

12​

4​

34%

CAT

<tbody>
</tbody>

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

Isthis something can be explained easily?

Any help appreciated!