niallmurph
New Member
- Joined
- Jun 11, 2008
- Messages
- 16
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…
<tbody>
</tbody>
AndRow 5 contains…
<tbody>
</tbody>
AndRow 9 contains…
<tbody>
</tbody>
ThenI'd like to consolidate those rows into a single aggregated row.
Isthis something can be explained easily?
Any help appreciated!
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!