Have DATA in one column:
1487 replaces 1487P
1508 replaces 1508P
1518 replaces 2809, 47-7900, 703247
1518 replaces 47-7900, 703247
1518 replaces 703247
1521 replaces 1521P
1528 replaces 208173, 252-88, 47-9600, 705478
1528 replaces 252-88, 47-9600, 705478
1528 replaces 47-9600, 705478
1528 replaces 705478
1535 replaces 1535P
3715 replaces 3139, 5234, 7582, 7585
3715 replaces 5234, 7582, 7585
Only want to keep the most unique data:
1487 replaces 1487P
1508 replaces 1508P
1518 replaces 2809, 47-7900, 703247
1521 replaces 1521P
1528 replaces 208173, 252-88, 47-9600, 705478
1535 replaces 1535P
3715 replaces 3139, 5234, 7582, 7585
Need help on a VBA code to sort out the most unique data.
Thank you in advance for any help.
1487 replaces 1487P
1508 replaces 1508P
1518 replaces 2809, 47-7900, 703247
1518 replaces 47-7900, 703247
1518 replaces 703247
1521 replaces 1521P
1528 replaces 208173, 252-88, 47-9600, 705478
1528 replaces 252-88, 47-9600, 705478
1528 replaces 47-9600, 705478
1528 replaces 705478
1535 replaces 1535P
3715 replaces 3139, 5234, 7582, 7585
3715 replaces 5234, 7582, 7585
Only want to keep the most unique data:
1487 replaces 1487P
1508 replaces 1508P
1518 replaces 2809, 47-7900, 703247
1521 replaces 1521P
1528 replaces 208173, 252-88, 47-9600, 705478
1535 replaces 1535P
3715 replaces 3139, 5234, 7582, 7585
Need help on a VBA code to sort out the most unique data.
Thank you in advance for any help.