Sunday, 21 July 2013

[ ::: ♥Keep_Mailing♥ ::: ]™ The Faster Way to Compare 2 Lists in Microsoft Excel




A Ridiculously easy and fun way to compare 2 lists

Compare 2 lists of Data in Excel - Conditional Formatting Tip[works only Excel 2007]

  1. Select cells in both lists (select first list, then hold CTRL key and then select the second)
  2. Go to Conditional Formatting > Highlight Cells Rules > Duplicate Values
  3. Press ok.
  4. There is nothing do here. Go out and play!

See the screen-cast aside to see how this works (click here for a detailed demo).

 

M Junaid Tahir 

Twitter LinkedIn Blogger Facebook Google Plus
Twitter  Latest tweet: Tech: The world's first talking parking ticket: The world's first talking parking ticket has been developed to... http://t.co/exLSBeXJn5Follow @JunaidTahir Reply Retweet 10:09 Jul-21



--
You received this message because you are subscribed to the Google Groups "Keep_Mailing" group.
To unsubscribe from this group and stop receiving emails from it, send an email to keep_mailing+unsubscribe@googlegroups.com.
To post to this group, send email to keep_mailing@googlegroups.com.
Visit this group at http://groups.google.com/group/keep_mailing.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

No comments:

Post a Comment