Consolidating Rows based on multiple matching criteria

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…

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!


 

Some videos you may like

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

Watch MrExcel Video

Forum statistics

Threads
1,109,020
Messages
5,526,293
Members
409,694
Latest member
bastos21

This Week's Hot Topics

Top