How to identify the duplicate in a instrument Name.

[ajmal pottekattil yoousuf]

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.

[#2]

@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

[#3]

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

[#4]

@ajmal pottekattil yoousuf 

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