You're welcome Lawrence, just a little extra, although that formula
works fine, it does a little bit of extra un-necessessary work.
It's more efficient to set the range to be checked like this
=COUNTIF(A$1:A$1000,A1)
this saves on recalculation time but loses the dynamic capability.

HTH
Martin


"FLKulchar" wrote in message
...
Thank you -- works perfectly!!

FLKulchar
"MartinW" wrote in message
...
Hi Lawrence,

With your data in column A put this in B1 and double click
on the fill handle. (or drag down to the end of your data)
=COUNTIF(A:A,A1)

It will return 1 for a single entry and 2 or greater for duplicates.

HTH
Martin


"F. Lawrence Kulchar" wrote
in message ...
I have a column of names, in alphabetical order.

How can I see if I, perhaps, hve entered a name MORE THAN ONCE; in other
words, the listing would appear at least twice...consecutive rows would
have
identical data -- which I wish to avoid??

Thank you,

FLKulchar