Data Validation

[Sincity_Jason]

Heres one for you guys.. should be easy enough. I have a column A, which is fomatted with a data validation = to range("name"). Need to have a vba code to check for duplicate values, then show msgbox, then goto duplicates for rentry. Here's the quirk. In Between the values that are entered there will be many blanks. So hence the countif function in the valdition allow box..doesn't work..Any ideas..

Jason

 

[BigC]

Jason
Can you not expand the COUNTIF (perhaps with array formula) to include two conditions:
condition 1: values <> blank
condition 2: value count > 1

HTH

 

[Sincity_Jason]

Thats works great except for one minor problem. I lose my list to choose from.. Need to be able to choose from a list, and on exit or change, have the validation work..Thanks for help with countif, im sure i'll use it elsewhere.. what do you think can it be done..