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.