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.
3 Replies
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.
