How to identify the duplicate in a instrument Name.

Iron Contributor

Here the User Enter the Value in different type.

In conditional Formatting "Duplicate function" is used.

But it couldn't find the duplicate.

Please refer the attachment.

3 Replies

@ajmal pottekattil yoousuf 

But you have no one duplicate in that list. Marked with red values are different, e.g.

Internal Taper Gauge ( Dial Indicator)

Internal Taper Gauge (Dial Indicator)

- space/no space after the first bracket


Actually is typo error. Physically both the instrument are same.

@ajmal pottekattil yoousuf 

But Excel has no idea is that a typo or not. You shall to correct all typos first.