comparing columns of names

[Talbott]

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!

 

[Asala42]

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.

Adam

 

[Mark W.]

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.