Find values in column A, that are in column B

[AdamA]

Guys.

I need some help on Excel. I have two columns, A and B. Within these two columns are a list of numbers. I need to be able to identify in column A which values have a match in column B. Either highlighting them on the sheet, or placing them into a new column, C

Is this possible?
Thanks
Adam

 

[Richard Schollar]

Hi Adam

Select Column A and go Format>ConditionalFormatting (pretty sure the CF button is on the Home ribbon tab). Change to Formula Is and type in the following formula:

=COUNTIF($B:$B,$A1)

and hit the Format button and apply a Pattern of eg Red to the cell. Hit OK.

This will colour A column cells with a value that also appears in Column B.

 

[Trevor G]

Try using conditional formatting and using countif

Excel Workbook
	G	H
1	First	Second
2	234	543
3	4567	5678
4	5678	4321
5	4321	234111
Cond Formatting Duplicates

Formula in Conditional formatting is on Selecting column G then using conditional formatting and Formula

=COUNTIF(H:H,G1)>0

Used Colour Green

 

[AdamA]

Simples. Thanks so much.

Adam