ExcelBanter - data validation in Execl 2007

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

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

- - data validation in Execl 2007 (https://www.excelbanter.com/new-users-excel/171081-data-validation-execl-2007-a.html)

pcor

data validation in Execl 2007

I want to restrict duplicates names in Col B.I forgot how to do that using
data validation. Can someone help.Thanks

David McRitchie

data validation in Execl 2007

see
Excel -- Data Validation -- Custom Validation Criteria Examples
http://www.contextures.com/xlDataVal07.html

--
HTH,
David McRitchie, Microsoft MVP -- Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm

"pcor" wrote in message ...
I want to restrict duplicates names in Col B.I forgot how to do that using
data validation. Can someone help.Thanks

pcor

data validation in Execl 2007

Work fine many thanks

"David McRitchie" wrote:

see
Excel -- Data Validation -- Custom Validation Criteria Examples
http://www.contextures.com/xlDataVal07.html

--
HTH,
David McRitchie, Microsoft MVP -- Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm

"pcor" wrote in message ...
I want to restrict duplicates names in Col B.I forgot how to do that using
data validation. Can someone help.Thanks

All times are GMT +1. The time now is 01:00 AM.