 | Comparing two Lists In Excel |  |
|
Added to Library on 20 Apr 2008
Length: 5 mins
View Tutorial Movie
Download File Used |
One of the great things that Excel is good at is comparing two sets of data to determine what has changed in each set. This tutorial will show you how to do this manually (very time consuming and not recommended) and how to set up a simple Excel formula to find the differences automatically.
With the techniques shown in this tutorial you will be able to quickly compare lists of customers, emails address, postcodes or in fact anything at all.
|
|
Related Tutorials:
Cell Referencing
Finding Duplicates in a list
Removing Duplicates from a list
|
Feedback for this tutorial:
"Clayton - another most useful and informative tutorial - for which many instances this will be a time saver !"
"This is a sortable easy method. Could be graded as Intermediate. Thank you."
"Wonderful, I love it"
"Thank you, I have to compare lists all teh time.
So this is very useful for me.
A great function.
Michael"
"A great tutorial, as usual. I'm always fearful of using 'IF' statements in Excel, but whenever you demonstrate how easy they are I resolve to give them a try. I find that your consistent phrases in the commentary make it easy for me to learn how to enter the information required."
"Excellent choice. It was something really simple but I was not aware off. I am going to use it from now on a lot. One of your best tips."
"Wonderful and terribly handy ! Thank you so much."
"EXCELLENT! I HAVE WONDERED HOW TO DO THIS."
"Found Very useful just what I needed as I normally use access which can be very time consuming "
"I feel that, as usual, Clayton has come up with another unusal way to do something in Excel, as he has so many other times. Thank You Clayton. Jack"
"Thank you. I keep yearly lists of donors to a nonprofit organization and this will help us maintain them."
"Thanks, Clayton. I have been looking for an easy method to compare two lists and you have provided it. This will save me countless time."
"I have to compare cell phone numbers to list of employees. I like the way this compares list to list. "
"it's great, i love it and it's very helpful..
thanks,
Mark"
"Very informative, I like these tutorials a lot, one can really learn something... I always do."
"i am amazed how usedful it is! to be honest i was sceptical about this and i didn't expect it to be so helpful, easy to understand and what is more important , it concerns more complicated issues.
"
"Hey Clayton, I love this tutorial. This is another great example of how you take tasks that at first may seem complicated and then show how easy they really are once you know the correct tricks. Many Excel users will be happy when they discover how much time this one can save them. Keep the tutorial coming, they are great! -- Francis"
"This tutorial was brilliant, I always went around it the long way by just using the sort facility. Now I will have spare time to do other jobs, now that I can compare my lists with the nested IF and Countif functions. Thank you!"
"Nice way to view current month end inventory vs. prior months looking for new items."
"Very helpful simple way of comparing lists - I wish I had known this techniques several weeks ago. I had to do a comparison of two lrists of retail stores to see which ones were unique to both. I did it manually, this would have been so much faster. "
"The tutorial was easy to follow and all of its explanations were more than sufficient to do the task."
"THis is wonderful. keep up the good work."
"Wow...I've used the IF and COUNTIF functions quite a bit, but it's never occurred to me to use them in this fashion. This is going to be profoundly useful at work as I go through lists like this all the time! "
|
|
|
| |
 | |  |
|
|
|
