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...
i also experience the same problem, i deal with barcodes and "case ids" at my work and case ids beginning with "001" always return to me as duplicate values, and in my current workbook even appear to be sorted as such when using advance search
| 00112000020002097792 |
| 00112000020002097914 |
| 00112000020002097907 |
| 00112000020002097891 |
| 00112000020002097747 |
| 00112000020002097808 |
| 00112000020002097815 |
| 00112000020002097846 |
| 00112000020002097884 |
| 00112000020002097761 |
| 00112000020002097822 |
| 00112000020002097785 |
| 00112000020002097938 |
| 00112000020002097723 |
| 00112000020002097778 |
| 00112000020002097921 |
| 00112000020002097013 |
That's bit different issue. Comparing texts which looks like numbers conditional formatting converts them to numbers and compares the latest. Comparing the numbers all what after first 15 digits is ignored. Same behaviour has COUNTIF().
To prevent conversion we may use such trick: