Find duplicate names in column

[village idiot]

I have a column that has people's names in it. Is there a way that I can search to see if a name has been entered more than once?

 

[nisht]

Download the file nos 7 and file nos 19 from

http://www.pexcel.com/download.htm

if you dont want to enter duplicate entry in column then see file nos.27

it exactly what you want.

ni****h desai
http://www.pexcel.com

 

[Mark W.]

Why not create a PivotTable with 'Count of Name' in DATA area and 'Name' in the ROW area?