Comparing two columns

[mame]

I have two columns of ID's, A and B. I want to know if each value in column A is in column B.

There's got to be an easy formula for this...thoughts?

[Palmetto]

Copy this formula another column and drag it down the column as needed. It will count if the values in "A" appear in "B". Adjust range to suit.

=COUNTIF($B$2:B100,A2)

[mame]

Copy this formula another column and drag it down the column as needed. It will count if the values in "A" appear in "B". Adjust range to suit.

=COUNTIF($B$2:B100,A2)

Great, that gives me a column of 1's and 0's. Now I want to get just the EMPLID's that have a '1' associated with it.

I could use a filter to do this, but is there another formula that I can use? I'm just wondering how you Excel guru's do this kind of thing.

[Palmetto]

Use Auto-Filter to show only the rows that have a "1" then copy the visible rows.

Optional:
Pivot Table using the column counting column as the Page Field and show only "1"

Or

Use Advanced Filter with criteria to extract the records where the value is equal to "1".