Ghesselink
New Member
- Joined
- Jun 7, 2018
- Messages
- 20
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
X, 0/blank
X, 0/blank
Y, 200
Y, 0/blank
Y, 0/blank
Z, 100
Z, 0/blank
Z, 0/blank
The problem is, if I usually delete duplicates the '100' of the 'Z' row will be deleted as well.
Is there any way to solve this?
Thanks in advance,
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
X, 0/blank
X, 0/blank
Y, 200
Y, 0/blank
Y, 0/blank
Z, 100
Z, 0/blank
Z, 0/blank
The problem is, if I usually delete duplicates the '100' of the 'Z' row will be deleted as well.
Is there any way to solve this?
Thanks in advance,