ExcelBanter - Data Validation

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Data Validation (https://www.excelbanter.com/new-users-excel/11783-data-validation.html)

Mohamed

Data Validation

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

--
Regards Ron de Bruin
http://www.rondebruin.nl

"Mohamed" wrote in message ...
Hi, How can i prevent duplicate of data in a coloumn using data validation

JulieD

Hi

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

for full details on how to do this.

Cheers
JulieD

"Mohamed" wrote in message
...
Hi, How can i prevent duplicate of data in a coloumn using data validation

All times are GMT +1. The time now is 03:46 AM.