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