Remove duplicate values in table

Hi all,

I have a table that goes from A4 to I200 (but this could often change).

In each cell there are a number of duplicate locations like this Oldham, Oldham, Chesterfield, Pendle, Pendle (obviously the actual location can vary).

I am looking for something to go through the table and only remove duplicates within the same cell, as F4 and G4 could have the same locations in it, but I only want duplicates removed if they are duplicated within the same cell.

Finally, some of these cells will be coloured - which needs to be retained.

At present I have only been able to remove duplicate cells, i.e where two cells match, not when looking at the string itself.

Any help appreciated.

How about

Please Login or Register  to view this content.