Cell Comparison

[Guest]

I have two columns and I wish to compare column a to b. I want to have column c to tell me which cells of column a are also values of column b

I try the exact funcion but it didn't work. Please help

Thank you.

 

[Frank Kabel]

Hi
try in C1 the following formula
=IF(COUNTIF(B:B,A1)>0,"cell in column A is within column B","")
and copy down

 

[Harald Staff]

Hi

Try in C1:
=MATCH(B1,$A$1:$A$1000,0)

It returns error NA for no match, first found matching rownumber in A on
match.

--
HTH. Best wishes Harald
Followup to newsgroup only please

I have two columns and I wish to compare column a to b. I want to have

column c to tell me which cells of column a are also values of column b.

 

[Dave Peterson]

I use Harald's suggestion with a minor tweak:

=MATCH(B1,$A$1:$A$1000,0)
becomes
=isnumber(MATCH(B1,$A$1:$A$1000,0))

True means it matched; false means nope.

I like to apply Data|Filter|autofilter to that range and it makes this a little
easier to filter.