If I let Excel highlight two duplicate values PT_INTERNAL2859736
, then also unique value *736
gets highlighted. Why this happens and how can I stop highlighting the unique value as duplicate?
I thought the Duplicate Values rule is reliable until I found this case.
The problem can be reproduced based on the image.
Now, if you reproduced the behavior, try to delete one of PT_
values. The other will lose the highlighting but the *736
will keep it!
Is this an expected behavior of the Duplicate Values functionality (usefulness of which I am overlooking)? Or is this rather a defect which has to be reported?
Update by iliansky (2021-01-25):
Similar undocumented behavior can also be observed with other symbols such as <
, >
, <=
, >=
when these symbols are placed in the beginning of the text in a cell and there are 2 or more non-empty cells in the column.
See an example here (each column is a separate example).
This might become an issue when processing xml files where the lines normally start with <
.
*
asterisk is seen as a wildcard character. Never encountered this "feature" before. Here someone did have the same issue