Compare Two Excel Lists to Spot the Differences

Posted: May 15, 2010
Description

Over time you will collect many lists of Excel data. It can be a challenge to compare the contents of one list with the contents in another list. For example, to find out which customers do not exist in another list. In this lesson I demonstrate three techniques that you can use to compare Customer lists: 1) The =MATCH() Function 2) The VLookup() Function 3) Pivot Tables I invite you to visit my website - www.thecompanyrocks.com - to view all of my video lessons.

URL: http://www.celebritynetworth.com/watch/pnjcMksnU9U/compare-two-excel-lists-spot/

Video Tags

Tech, MS, Microsoft, Excel, 2007, Match, VLookup, Functions, Pivot, Tables, Compare, Lists, Formula, Errors, Lessons, Tutorial, Software, Instruction, How, to, Append, Data

Discussion