Hi,
I have a spreadsheet with just three columns but after using the Conditional Formatting to highlight duplicate values from column A (Name) there are duplicates present as per the first table below. I need to get to a stage as per the second example whereby the duplicate Names have been merged together and the data on each of their rows are summed up.
Is there a formula I can use that will allow me to do this? There would only ever be two duplicate Names if that helps at all.
I look forward to receiving any responses.
<tbody>
</tbody>
<tbody>
</tbody>
I have a spreadsheet with just three columns but after using the Conditional Formatting to highlight duplicate values from column A (Name) there are duplicates present as per the first table below. I need to get to a stage as per the second example whereby the duplicate Names have been merged together and the data on each of their rows are summed up.
Is there a formula I can use that will allow me to do this? There would only ever be two duplicate Names if that helps at all.
I look forward to receiving any responses.
Name | Number of Transactions | Spend |
AA | 2 | £10 |
BB | 3 | £15 |
CC | 4 | £25 |
AA | 5 | £20 |
<tbody>
</tbody>
Name | Number of Transactions | Spend |
AA | 7 | £30 |
BB | 3 | £15 |
CC | 4 | £25 |
<tbody>
</tbody>