How to find repetition of data in cells in a column?

[Joseph T J]

I have to check repetition of data in cells in a column. For eg. i want to
check if data in D3 cell is repeating in any cell other cell in D column

 

[Dave Peterson]

Chip Pearson has some techniques at:
http://www.cpearson.com/excel/duplicat.htm