Forum Discussion

Brass Contributor

Oct 07, 2021

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...

duplicates.xlsx10 KB

excel

Formulas and Functions

office 365

Riny_van_Eekelen

Platinum Contributor

Oct 07, 2021

Elipum Clearly, the texts you included in your question contain no duplicates. So, there must be something else triggering the warning. And I suspect that you are trying to set relationships between two tables.

Elipum

Brass Contributor

Oct 07, 2021

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?

Riny_van_Eekelen
Platinum Contributor
Oct 07, 2021
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?
- Elipum
  Brass Contributor
  Oct 07, 2021
  Of course. Just loaded the file to the main post now.
  - Riny_van_Eekelen
    Platinum Contributor
    Oct 07, 2021
    Elipum ???? There are no duplicates in this file.