Matching up data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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)
 
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
 
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)
 
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
 
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)
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Matching 2 columns 3
Lookup multiple cell values and place contents in a single cell 3
match and sort two different tables 2
Match Function 4
Multiple List Analysis 0
Compare value to range, return matched value 2
matching & combining data from seperate worksheets 2
In Need of proper conditional formula 1

Back
Top