View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Alphabetical Order (check for duplicates)

Hi,

An excellent source for code, formula and formatting that checks for
duplicates is here

http://www.cpearson.com/excel/Duplicates.aspx

Mike

"F. Lawrence Kulchar" wrote:

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