Forum Discussion
Weird. Duplicated values highlighted in Excel, but they are clearly not duplicates!
In excel, I am getting warning of duplicated values from this list. This prevents me from creating a data model relationship one to many. However, the values are not duplicated at all: 2.05.1...
Elipum I'm struggling with a similar issue with non-duplicate cells being conditional-formatted as duplicate.
In my case (by complete chance) I may have stumbled on the error.
I have found two cells with "12-14" and "14-12" which throw up a duplicate.
Both cells are formatted as "Text".
I suspect the non-numerical entry (for me the minus sign) may be the problem.
Not very helpful though ... as I don't have a solution!