From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 23,200 courses taught by industry experts.

Use Data Validation based on multiple criteria

Use Data Validation based on multiple criteria - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Use Data Validation based on multiple criteria

“

- [Instructor] When you need to control what goes 2 into a worksheet, there's no better tool 3 than Excel's data validation feature. 4 We're setting up a list here 5 and in column B, we need employee ID 6 and it must adhere to three requirements. 7 It's got to be six characters long, exactly. 8 The five rightmost characters need to be numeric, 9 but the first character must be an uppercase letter. 10 If we are only concerned 11 with length already built into data validation by way of 12 that feature found on the data tab in the ribbon. 13 If we go to the data tab, choose data validation 14 for the entries that will go in column B, 15 we could on the settings tab here, under allow, 16 make the choice text length. 17 And instead of choosing a minimum, maximum, 18 we'll choose equal to six. 19 And that's just fine, that's all we need to do. 20 But if we have other requirements 21 and these aren't available by way of…

Contents