SOLVED

Value not same but is highlighted as duplicate in conditional formatting.

Copper Contributor

Hi,

 

I would like to check if anyone know that how this possible when the value is not same in the spreadsheet, but it highlighted as duplicate value in conditional formatting. 

 

I try using Remove duplicate function it does not identified it is duplicate.

Keat_Koid_0-1703649953475.png

 

3 Replies
best response confirmed by Keat_Koid (Copper Contributor)
Solution

@Keat_Koid Excel sees these as very large numbers but can't handle more than 15 digits. And looking at the first 15 digits only, the cells marked are indeed duplicates.

Haven't yet discovered a way to avoid this, other than putting an alpha-character before (tough not an apostrophe) or after the code.

@Keat_Koid 

Alternatively you may apply conditional formatting rule as

image.png

with rule formula

=COUNTIF($A$1:$A$6, CHAR(173) & A1 ) > 1
1 best response

Accepted Solutions
best response confirmed by Keat_Koid (Copper Contributor)
Solution

@Keat_Koid Excel sees these as very large numbers but can't handle more than 15 digits. And looking at the first 15 digits only, the cells marked are indeed duplicates.

Haven't yet discovered a way to avoid this, other than putting an alpha-character before (tough not an apostrophe) or after the code.

View solution in original post