Matching up data
 

I have a list in column C that has thousands of different company names
and I am trying to see which names in column C match up with the names in
column B which has hundreds of names.

Matching up data
 

Hi,

Try the tips on this site
http://www.j-walk.com/ss/excel/usertips/tip073.htm


hth
regards from Brazil
Marcelo

"Filter by first letter" escreveu:

I have a list in column C that has thousands of different company names
and I am trying to see which names in column C match up with the names in
column B which has hundreds of names.

Matching up data
 

I would use conditional formatting.

Select all cells in column C, assuming starting at C1,
Goto FormatConditional Formatting
Change Condition1 to Formula Is
Add a formula of =ISNUMBER(MATCH(C1,B:B,0)
Select the pattern tab
Select a colour
OK out

all items in C that are also in B will show in colour.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Filter by first letter"
wrote in message ...
I have a list in column C that has thousands of different company names
and I am trying to see which names in column C match up with the names in
column B which has hundreds of names.

Matching up data - BOB?
 

Bob I did exactly what you ask - but I do not get any colour differential, I
know for a fact that there are 200 names that are in both lists.
Very frustrated here

"Bob Phillips" wrote:

I would use conditional formatting.

Select all cells in column C, assuming starting at C1,
Goto FormatConditional Formatting
Change Condition1 to Formula Is
Add a formula of =ISNUMBER(MATCH(C1,B:B,0)
Select the pattern tab
Select a colour
OK out

all items in C that are also in B will show in colour.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Filter by first letter"
wrote in message ...
I have a list in column C that has thousands of different company names
and I am trying to see which names in column C match up with the names in
column B which has hundreds of names.

Matching up data - BOB?
 

There was a missing ) in my formula

=ISNUMBER(MATCH(C1,B:B,0))

does that fix it?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Filter by first letter"
wrote in message ...
Bob I did exactly what you ask - but I do not get any colour differential,
I
know for a fact that there are 200 names that are in both lists.
Very frustrated here

"Bob Phillips" wrote:

I would use conditional formatting.

Select all cells in column C, assuming starting at C1,
Goto FormatConditional Formatting
Change Condition1 to Formula Is
Add a formula of =ISNUMBER(MATCH(C1,B:B,0)
Select the pattern tab
Select a colour
OK out

all items in C that are also in B will show in colour.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Filter by first letter"
wrote in message
...
I have a list in column C that has thousands of different company
names
and I am trying to see which names in column C match up with the names
in
column B which has hundreds of names.

Matching up data - BOB?
 

sorry it does not fix it,
There are no cells with a red format like I set up

I also tried =IF(C2=C3,1,IF(C2=C1,1,""))
which works in another spreadsheet (numbers), but does not here for some
reason


"Bob Phillips" wrote:

There was a missing ) in my formula

=ISNUMBER(MATCH(C1,B:B,0))

does that fix it?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Filter by first letter"
wrote in message ...
Bob I did exactly what you ask - but I do not get any colour differential,
I
know for a fact that there are 200 names that are in both lists.
Very frustrated here

"Bob Phillips" wrote:

I would use conditional formatting.

Select all cells in column C, assuming starting at C1,
Goto FormatConditional Formatting
Change Condition1 to Formula Is
Add a formula of =ISNUMBER(MATCH(C1,B:B,0)
Select the pattern tab
Select a colour
OK out

all items in C that are also in B will show in colour.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Filter by first letter"
wrote in message
...
I have a list in column C that has thousands of different company
names
and I am trying to see which names in column C match up with the names
in
column B which has hundreds of names.

Matching up data - BOB?
 

Your new formula has nothing to do with comparing one column against another
AFAICS.

Sounds like you have no full matches. Are you sure that some of the seeming
matches do not have extra spaces, probably at the end?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Filter by first letter"
wrote in message ...
sorry it does not fix it,
There are no cells with a red format like I set up

I also tried =IF(C2=C3,1,IF(C2=C1,1,""))
which works in another spreadsheet (numbers), but does not here for some
reason


"Bob Phillips" wrote:

There was a missing ) in my formula

=ISNUMBER(MATCH(C1,B:B,0))

does that fix it?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Filter by first letter"
wrote in message
...
Bob I did exactly what you ask - but I do not get any colour
differential,
I
know for a fact that there are 200 names that are in both lists.
Very frustrated here

"Bob Phillips" wrote:

I would use conditional formatting.

Select all cells in column C, assuming starting at C1,
Goto FormatConditional Formatting
Change Condition1 to Formula Is
Add a formula of =ISNUMBER(MATCH(C1,B:B,0)
Select the pattern tab
Select a colour
OK out

all items in C that are also in B will show in colour.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Filter by first letter"

wrote in message
...
I have a list in column C that has thousands of different company
names
and I am trying to see which names in column C match up with the
names
in
column B which has hundreds of names.

Matching up data - BOB?
 

you are probably correct - Thank you Bob

"Bob Phillips" wrote:

Your new formula has nothing to do with comparing one column against another
AFAICS.

Sounds like you have no full matches. Are you sure that some of the seeming
matches do not have extra spaces, probably at the end?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Filter by first letter"
wrote in message ...
sorry it does not fix it,
There are no cells with a red format like I set up

I also tried =IF(C2=C3,1,IF(C2=C1,1,""))
which works in another spreadsheet (numbers), but does not here for some
reason


"Bob Phillips" wrote:

There was a missing ) in my formula

=ISNUMBER(MATCH(C1,B:B,0))

does that fix it?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Filter by first letter"
wrote in message
...
Bob I did exactly what you ask - but I do not get any colour
differential,
I
know for a fact that there are 200 names that are in both lists.
Very frustrated here

"Bob Phillips" wrote:

I would use conditional formatting.

Select all cells in column C, assuming starting at C1,
Goto FormatConditional Formatting
Change Condition1 to Formula Is
Add a formula of =ISNUMBER(MATCH(C1,B:B,0)
Select the pattern tab
Select a colour
OK out

all items in C that are also in B will show in colour.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Filter by first letter"

wrote in message
...
I have a list in column C that has thousands of different company
names
and I am trying to see which names in column C match up with the
names
in
column B which has hundreds of names.