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!
Rakeshgopal.com
http://www.youtube.com/creativecommit
Thursday, February 17, 2011
Monday, June 28, 2010
Subscribe to:
Posts (Atom)