From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,400 courses taught by industry experts.

Prevent and locate duplicate worksheet entries

Prevent and locate duplicate worksheet entries - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Prevent and locate duplicate worksheet entries

- [Instructor] Duplicate values, 2 particularly the unintended ones, 3 sometimes cause big problems 4 when you're working with data in Excel. 5 Here's a list on this worksheet that we're about to set up. 6 Eventually, it's going to be quite large. 7 We want to make sure that 8 when an ID number goes into column D here, 9 that it's unique, 10 different from all the others, 11 no duplicates allowed. 12 There's no quick, easy way to do this, 13 but we can use a feature called data validation. 14 and we'll be using a function called COUNTIF. 15 Over in column H, 16 I've got a list of some regions here 17 and a simple example of COUNTIF in cell G2. 18 It's simply in effect saying, 19 looking at this range here, 20 how often do we see West? 21 Well, it's four times. 22 Now selecting column D, 23 this is where the ID numbers will go, 24 let's go on the data tab up in the ribbon. 25 Off to data validation, 26 you'll…

Contents