Today morning I needed to compare 2 lists in order to find any missing data.
I didnt have SQL nor any other tools to play around with data.
I tried out this cool feature provided by excel, that got my job done:
1.Select cells in both lists
2.Go to Conditional Formatting > Highlight Cells Rules > Duplicate Values
3.Press ok.
4.There is nothing do here. Go out and try it!