I am looking for a way to remove duplicates from a specific range. I have read about the .RemoveDuplicates function in VBA but it doesn't seem to be what I need. In one row I may have a cells that include the following:
CHICKEN,SOUP,DOG,LOVER,SOUL,DRY,DOG,FOOD,ADULT,DOG
I would like this macro to clear cell contents of any duplicate values so that there is only one. The desired output of this example would be:
CHICKEN,SOUP,DOG,LOVER,SOUL,DRY,FOOD,ADULT
For simplicity's sake lets say that these cells are A1:J1
I will have this formula loop through thousands of ranges and I can customize that but for now all I need is to know how to remove duplicates within rows without deleting entire rows or columns, just clearing cell contents of duplicates.
Thanks!
Bookmarks