Hi one and all
Want to do a look for duplicate and if yes then append data.
Example
Column 1 Column 2
1234 product1
1234 product 2
1234 product 3
i would like it find where column 1 contains a duplicate then if yes
append the data or copy it into column 2, and 3 and 4
Column 1 Column 2 Column 3 Column 4
1234 product1 product 2 product 3
1234 product 2
1234 product 3
Possible?
Thanks
If possible also to mark in column 5 as a dup like this
Column 1 Column 2 Column 3 Column 4 Column 5
1234 product1 product 2 product 3
1234 product 2 Dup
1234 product 3 Dup
--
HUBBUB88
------------------------------------------------------------------------
HUBBUB88's Profile:
http://www.excelforum.com/member.php...o&userid=24416
View this thread:
http://www.excelforum.com/showthread...hreadid=474834