Forum Discussion
How to find the duplicate
| CASINETTO TRADING LLC , PO BOX : 125905 , DUBAI , UAE |
| CASINETTO TRADING LLC, PO BOX: 125905, DUBAI, UAE |
In this condition, both customers are the same.
In conditional formatting, the duplicate is used. But conditional formatting duplicate is not working
If the spaces are the only difference:
Let's say your data are in column D.
Insert an empty column next to it, i.e. in column E.
In E1, enter the formula
=SUBSTITUTE(D1, " ", "")
Fill down.
Use conditional formatting on column E to highlight duplicates.
