information looks like this, and I have duplicate part numbers. I need to delete the duplicate rows, and sum the total column (E)
Can anyone help? I cannot use a pivot table.....
information looks like this, and I have duplicate part numbers. I need to delete the duplicate rows, and sum the total column (E)
Can anyone help? I cannot use a pivot table.....
Last edited by JetRich; 01-23-2014 at 01:55 PM.
Added a copy of the sheet.
Do you want delete duplicates from the table or you want calculation of total without duplicates?
Last edited by AlKey; 01-23-2014 at 02:22 PM.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
I need to calculate a total qty and $ for each part number.
Did you look at the attached file?
Yes, I looked at it. Looks like the duplicates are identified, but not removed?
Here is without duplicates
ok, this is great, but how do I apply that to the entire spreadsheet of 5k part numbers?
If you using excel 2007 or 2010
Click on any area in your data table, go to Data located on the ribbon and click on Remove Duplicates, click on Unselect All, then check PIN column and click Ok.
There is a button on sheet1. When you click it, the out put would be in a new sheet. It is a macro, not a formula.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks