Data Validation

Sincity_Jason

New Member
Joined
Sep 27, 2002
Messages
11
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
 

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

BigC

Well-known Member
Joined
Aug 4, 2002
Messages
851
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

New Member
Joined
Sep 27, 2002
Messages
11
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..
 

Forum statistics

Threads
1,144,510
Messages
5,724,782
Members
422,578
Latest member
annsalinas

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top