Loading...

Compare Two Excel Lists to Spot the Differences

458,498 views

Loading...

Loading...

Transcript

The interactive transcript could not be loaded.

Loading...

Loading...

Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on May 15, 2010

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.

Loading...

Advertisement
When autoplay is enabled, a suggested video will automatically play next.

Up next


to add this to Watch Later

Add to

Loading playlists...