Matching up data

  • Thread starter Filter by first letter
  • Start date
F

Filter by first letter

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.
 
B

Bob Phillips

I would use conditional formatting.

Select all cells in column C, assuming starting at C1,
Goto Format>Conditional 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)
 
F

Filter by first letter

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
 
B

Bob Phillips

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)
 
F

Filter by first letter

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
 
B

Bob Phillips

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)
 
F

Filter by first letter

you are probably correct - Thank you Bob

Bob Phillips said:
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)
Click to expand...
 
Top