Hello, this is my first post on this site and I could us some help. I'm not an Excel formula guru, but am wondering if it would be a formula I would need or if I need to write the comparison loop in VB.net. I have a table being exported from Autocad that I'm going to create a Bill Of Materials from. It would have a column named Part Number, and would look similar to this:

480-244-292
480-244-263
480-244-278
480-244-286
480-244-269
480-244-292
480-244-278

And on, and on. What I'm going to do is have another column named Qty. and I need to go through the list of part numbers and when it sees a duplicate part number add 1 to the Qty. and delete the row with the duplicate part number. Basically condensing the table down. I appreciate any help.