Friday, 10 October 2014

Identify Duplicate/ common in two data sets

In case if you have two sets of list and you want to see all the common names in it, easier , simple and quicker way.

 

a)      Select two lists

b)      Go to Conditional formatting

c)      Select highlight Duplicates and see the magic

 

 

 

 

No comments:

Post a Comment