Hello,
I'm trying to remove duplicate values, however the problem is that by the usual conditional formatting method I will also delete duplicates I do not want to delete.
The datasets is at follows:
X, 100
X, 100
X, 100
Y, 200
Y, 200
Y, 200
Z, 100
Z, 100
Z, 100
And I want to get to
X, 100...