Count and Report on Duplicates

[interwoven]

Hi,
I have a spreadsheet with 2 columns in it. One contains a UPC code the other contains a qty, ex:

UPC Qty
093524100011 1

I need to count and sum the number of duplicates in the UPC Column, ex:

UPC QTY
093524100011 1
093524100011 1
093524100011 1
093524100011 1
093524100023 6
093524100023 1
093524100023 1
093524100023 1

So I have:
UPC Qty
093524100011 4
093524100023 9


I actually found a macro in a post in here that works great but in the report it returns it strips out the leading 0 in the upc code:

http://www.excelforum.com/excel-prog...o-formula.html

Please Login or Register  to view this content.

This works great because I need the report returned in another sheet because I then run a script to append data from one sheet to another. Is there anyway to modify this script to leave the leading 0 alone ion the report? I have to go in and format the UPC column to text before I scan data into it and that takes care of it there but the report still strips off the leading Zero's

Thanks for any help!

[mrice]

Try this amendment.

Please Login or Register  to view this content.

[interwoven]

Thank you so very much. That seems to work perfectly!

Thanks again. I really appreciate you taking time to help me.