while entering text excel should not accept duplicate record..?
 

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.

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.