Forum Discussion
Elipum
Oct 07, 2021Brass Contributor
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...
Riny_van_Eekelen
Oct 07, 2021Platinum Contributor
Elipum ???? There are no duplicates in this file.
Elipum
Oct 07, 2021Brass Contributor
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!
- Riny_van_EekelenOct 07, 2021Platinum Contributor
Elipum Nope! I open your file and see this:
- ElipumOct 07, 2021Brass ContributorMay this be an Excel bug then? it has no sense...
- SergeiBaklanOct 07, 2021Diamond Contributor
Could you share the file with conditional formatting rule applied?