View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jan Buckley Jan Buckley is offline
external usenet poster
 
Posts: 16
Default identify duplicate data upon entry of that data

Is there a way to identify an entry as a duplicate in the same column. For
instance, if 4310011192 is already entered in the column and I enter it
again, an error will result, informing the user "Duplicate entry". I know you
can do this in ACCESS by virtue of the primary key, but don't know how to do
it in Excel.