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