I want to run a loop on a column that checks each row for duplicates WITHIN each cell and eliminates those duplicates. Thus, I would want:
Column A
1, 1, 2, 3
2, 2, 3
4, 5 , 6, 6
to become
Column A
1, 2, 3
2, 3
4, 5, 6
Any suggestions? Is there a command that counts the number of characters up until a certain character? Then I could say IF characters until "," equal characters after "," THEN delete characters after ","
Much appreciation to anyone with thoughts!
Column A
1, 1, 2, 3
2, 2, 3
4, 5 , 6, 6
to become
Column A
1, 2, 3
2, 3
4, 5, 6
Any suggestions? Is there a command that counts the number of characters up until a certain character? Then I could say IF characters until "," equal characters after "," THEN delete characters after ","
Much appreciation to anyone with thoughts!