Data Validation-Multiple Criteria

  • I have a workbook containing 2 sheets. Sheet1-Col B, is where I enter names. I created a data validation drop down list sourced from Sheet 2 (formatted as a table) to assist with entering names. That validation list works fine.

    PROBLEM: I would like to keep the ‘select from list’ function AND add a ‘Unique value’ type condition to Sheet1-Col B so the same name cannot be entered twice. I know the formula =COUNTIF($B:$B,B2)<2 entered on the Data Validation formula section for Sheet1-Col B works to avoid duplicate entries.

    Can I keep the drop-down list and, also have a unique value type function in the same validation formula? If so, please help with how to do it. THANKS

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!