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