WEB LIFE
GADGETS
SOFTWARE
STYLE
DOWNLOADS
SHOPPING
TECH SUPPORT

Tom's HardwareTom's IT Pro

Computing.Net

Excel - Comparing Lists

Tags:
excel
Score
0
Vote Up
August 23, 2011 at 13:34:15 Pacific
Specs: Windows XP

I am trying to compare two lists of cities in excel. I have them in alphabetical order, and each list has items that are not on the other, but also have duplications. I can't seem to figure out how to get a view, where they are side by side where they match (lining them up). Please let me know if anyone has any ideas! Thanks! EXAMPLE:

1
2 2
3 3
4
5
6
7 7


Reply ↓  Report •


#1
Vote Down
Score
0
Vote Up
August 23, 2011 at 17:40:15 Pacific

Your example is slightly confusing...maybe it's just incomplete.

You said:

"each list has items that are not on the other, but also have duplications"

In your example, I see items that are on your first list that are not on your second, and I see the duplicates that are lined up. What I don't see are any items on your second list that aren't on your first.

Is your example correct or should it be something like the following. I moved the 4 as an example of something that is on the second list but not on the first.

1
2      2
3      3
       4
5
6
7      7

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Reply ↓  Report •
Reply to Message Icon Start New Discussion
Related Posts
See More ↓

« Outlook won't permanently... need macro code for data »

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Ask the Community!
Describe your Problem
Example: Hard Drive Not Detected on My PC