Forum Discussion
How to identify the duplicate in a instrument Name.
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.
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.
But Excel has no idea is that a typo or not. You shall to correct all typos first.
