comparing columns of names

Talbott · May 13th, 2002, 08:48 AM

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 · May 13th, 2002, 08:50 AM

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. · May 13th, 2002, 08:51 AM

Quote:

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 13th, 2002, 08:48 AM	#1
Talbott New Member Join Date: May 2002 Location: Suburban KC Posts: 4	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!

May 13th, 2002, 08:50 AM	#2
Asala42 Board Regular Join Date: Feb 2002 Location: Southfield,MI USA Posts: 1,030	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