View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey
 
Posts: n/a
Default can i prevent duplications in cells

take a look he

http://cpearson.com/excel/NoDupEntry.htm

In article ,
Jackie wrote:

I am creating lists in Excel and I don't want information to be duplicated,
can I use a forlmula to prevent this?
A bit like a primary key in databases