Removing Duplicate Values Only

I have searched and searched but can't seem to find the answer I once had.

From A2:A159 I have a list of part numbers (no duplicates). Then for each part, from Column B through Column DX there are quantity values.

Going one row at a time, I need to delete all duplicate entries.

Considerations:

Rows are independant of each other and there may be similar quantity values for different parts.

Even though the range is from B to DX, each row is unique in the total values to be considered (they range from 100+ to 1).

I was attempting to modify the following code but to no avail:

Please Login or Register  to view this content.

Anyway, I am at a loss and need some help. I am attaching a copy of the file as well.

Thanks,

You can try this:
http://exceltips.vitalnews.com/Pages...ate_Cells.html

Type "the duplicate master" in to Google. It's a very good Excel add-in that I use a lot. Hopefully it will help you do what you need to do.

Originally Posted by ConfusedTech

You can try this:
http://exceltips.vitalnews.com/Pages...ate_Cells.html

That was sort of what I need. I needed something to remove duplicates by row whereas the link (along with all the other examples I found) was to do so by column. Anyway, I just modified it a bit to suit my needs.

I'll post my modified version for anyone else who might need by row versus by column.

Please Login or Register  to view this content.

If anyone uses this, for reference note the following portion:

Please Login or Register  to view this content.

You can change the 1 to 10 to suit the rows needed.


As far as The Duplicate Master goes, that worked as well (I tried both) and I am putting up the link I found it at for others.

http://members.iinet.net.au/~brettdj/


Thanks to both of you for your help.