Highlight Duplicates in Excel

sometime we have to highlight Duplicates in excel and later work on them rather then deleting them using option " Remove Duplicates " .
here we will use " Conditional Formatting " for finding-out duplicates .

Function to find Unique Items in a list

It happens many times when you are writing a Macro and you need to find the unique items out of the a range of items. Suppose you have an excel sheet that has the employee ids of you the people working in a company but the list has duplicate entries. Though there is a feature in excel where you can just display the unique name but to do the same using Macro you need to write a code.

Syndicate content

Suggested Book to learn VBA