I have a number of ids in two columns and am trying to represent which ones
in the second column also appear in the first.

One way...

Comparing column B to column A with the list in column A in the range
A1:A20.

=IF(COUNTIF(A$1:A$20,B1),"match","")

Copy down as needed.

--
Biff
Microsoft Excel MVP


"JoeM" wrote in message
...
I have a number of ids in two columns and am trying to represent which ones
in the second column also appear in the first.

"T. Valko" wrote...
One way...

And the slow way . . .

Comparing column B to column A with the list in column A in the range
A1:A20.

=IF(COUNTIF(A$1:A$20,B1),"match","")

Bit faster to use

=IF(COUNT(MATCH(B1,A$1:A$20,0)),"match","")

or just

=MATCH(B1,A$1:A$20,0)

which would return a number when there's a match and #N/A when there
isn't.

I'm bored too!

--
Biff
Microsoft Excel MVP


"Harlan Grove" wrote in message
...
"T. Valko" wrote...
One way...

And the slow way . . .

Comparing column B to column A with the list in column A in the range
A1:A20.

=IF(COUNTIF(A$1:A$20,B1),"match","")

Bit faster to use

=IF(COUNT(MATCH(B1,A$1:A$20,0)),"match","")

or just

=MATCH(B1,A$1:A$20,0)

which would return a number when there's a match and #N/A when there
isn't.

JoeM wrote:
I have a number of ids in two columns and am trying to represent which ones
in the second column also appear in the first.

Assuming your two columns are A and B, select column B and enter this for
conditional formatting:

=COUNTIF($A:$A,B1)0

Select the format you want to "represent" matches.

Apply the formula in C1 which will check the value of B1 in A and return Y or N

=IF(COUNTIF(A:A,B1)0,"Y","N")
--
If this post helps click Yes
---------------
Jacob Skaria


"JoeM" wrote:

I have a number of ids in two columns and am trying to represent which ones
in the second column also appear in the first.