View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default while entering text excel should not accept duplicate record..?

Look he

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"HAYAT" wrote in message ...
| Hi all,
| I want to make a list of companies names, (preferrabley in excel, access
| will be ok too). I want to avoid duplicates, e.g If I enter the same record
| again, It should not be accepted.