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

H

HAYAT

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.
 
N

Niek Otten

Look here:

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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.
 
Top