Data Validation

[Guest]

Hi, How can i prevent duplicate of data in a coloumn using data validation

 

[Ron de Bruin]

Hi Mohamed

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

 

[JulieD]

Hi

check out
http://www.cpearson.com/excel/NoDupEntry.htm

for full details on how to do this.

Cheers
JulieD