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...
If you copy those values in a blank excel, and set the conditional formating of: Highlight duplicate values, does this error also happen to you?
Elipum No. None are highlighted. But that may be because I'm copying some texts from this web site. Why don't you upload a file that demonstrates the problem?
- Of course. Just loaded the file to the main post now.
Elipum ???? There are no duplicates in this file.
Riny_van_Eekelen really? See screenshot. They do show as duplicates on my file (all red).
If you delete any of the cell values, one of the other cells becomes white, meaning, its duplicate has been deleted. But obviously they were not duplicates at all!
