Compare Data two Columns

[kodakvicky]

I need to compare the data in Column A with the Data in Column D. Column A has approx lines 1100 rowes with some duplicates. Column D contains 346 rows and no duplicates. I need to know which itmes in Column D are duplicated in Column A. When I do a duplicate search it also picks up the duplicates in Column A. I only want to know which items in D are also in A. I would like the the items in Column D that are duplicated in Column A to be highlighted

 

[PATSYS]

Highlight column D1:D146, click on FORMAT menu, CONDITIONAL FORMATTING, choose FORMULA IS, then type this formula:

=ISNUMBER(MATCH(D1,$A$1:$A$1100,0))

set the shading to desired, and click ok.

 

[sanrv1f]

Hello and welcome to the board,

assuming below as the sample data in column A

Excel Workbook
	A
1	AAA
2	BBB
3	CCC
4	AAA
5	DDD
6	EEE
7	BBB
8	AAA
9	FFF
10	EEE
Sheet1

Excel Workbook
	D
1	AAA
2	BBB
3	CCC
Excel 2003 and the column D looks like Sheet1

Excel 2003



select D1:D3 with D1 being the active cell,

goto -> Format -> Conditional formatting->Condition 1->Formula is ->

=COUNTIF($A$1:$A$10,D1)>1

choose the format, click ok

 

[Misca]

Try conditional formating with a formula. Select the cells in D-column and then type the following on the Conditional Formatting field:

=COUNTIF($A:$A,$D1)>1

You can find the Conditional Formatting from the Format-menu field. Also, because you want to use the formula, you have to check "Formula Is". And don't forget to choose how you want the cells to be highlighted before exiting the Conditional Formatting.