Forum Discussion
Combining Identical Cells While Totaling their Data
My sheet has many duplicate part numbers with various quantities and I desire to reduce this to one part number and the total quantity for each part number. Is there a pretty straightforward way to do this?
Sample attached....
Thank you,
Marty
2 Replies
Hi Martin
I've just retracted the earlier answer I have and have a better solution for you which I found here: https://www.extendoffice.com/documents/excel/1268-excel-combine-duplicate-rows-and-sum.htmlLet me contextualise it to your situation:
1. Highlight/Select the columns where you want the combined values to be (e.g. M, N, O, P).
2. Go to Data menu tab > look under Data Tools.
3. Click onto Consolidate.
4. Click onto the down arrow icon (to the left of Browse) and select columns A, B, C, D, press Enter.
5. Click onto the Add button.
6. Once this is added as a reference (should look like $A:$D), tick Left column.
7. Click OK.
Your Part numbers and associated values should now be consolidated into one entry!
I've also attached the sample file.
Let me know how you go?
Cheers
Damien- Thank you so much, Damien. I appreciate you taking the time to illustrate this. It worked great.
Cheers,
Marty
