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...
there's your duplicate values:
If they're phase numbers to a project you should format them as text or use a hyphen to make sure excel will automatically format them as text
I also noticed that you did put an " ' " and I also formatted the cells as text and yet the INT() function was still able to convert them as integers, now if the excel engine does that then they will always be duplicate values so then I added .00 after the first decimal point:
and it produced an error. #value as it does when I added a hyphen:
so its probably safer to either add a hyphen or add a decimal with trailing zeroes in order to be consistent