Thanks:  0
Likes:  0

# Thread: comparing columns of names

1. Two columns of Company names; we'll call them column #1 and column #2. Some names are duplicated from column #1 to column #2 and vice versa. I want to compare the columns and produce a list of those company names that are in column #1 but not in column #2 and vice versa.

HELP! and THANKS!

2. G'day,

Maybe there's a faster way, but you can use a pair of VLOOKUPs. Formula looks like this:

=VLOOKUP(A2,\$B\$2:\$B\$100,1,0)

-> that would give you a list from B that also exist in A.

3. On 2002-05-13 07:48, Talbott wrote:
Two columns of Company names; we'll call them column #1 and column #2. Some names are duplicated from column #1 to column #2 and vice versa. I want to compare the columns and produce a list of those company names that are in column #1 but not in column #2 and vice versa.

HELP! and THANKS!
=MATCH(A1,B:B,0) will return #N/A if the value in cell A1 isn't in column B:B. Copy this formula down for each value in column A:A.

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•