Is there a function in Kutools that will identify (preferably) or remove duplicate values (but leaving 1 x original value if removing duplicates) in a semicolon separated cell in Excel? My list is @ 150k rows, the cell with the values varies in length between approx. 15 to 65 values.
Example of the cell:
1;27;74;17;79;7;51;4;83;81;47;48;65;60;15;49;5;75;64;62;13;12;45;36;73;44;34;91;90;69;56;54;59;20;46;52;40;58;2;85;78;53;88;1
In this example i need to either identify the first & last values (1) or remove just one (the last one preferably).
Thanks!
Carl