Join Dennis Taylor for an in-depth discussion in this video Locating Data Validation rules and violations, part of Excel Tips Weekly.
- [Voiceover] Someone has just sent you an employee list,…like the one we see here, and as you start to make…certain entries and adjustments,…you realize there are some problems…that you can't quite figure out at first.…And data validation rules which are in this worksheet…in different locations at least initially might be…hard to track down unless you know…some of the techniques for getting there.…Imagine I'm making a change to one of the employee IDs.…I'm looking at a sheet of paper here,…and this particular employee ID here begins with zero.…So I'm double-clicking in this cell, D4.…Put in a zero, I press Enter.…
I get a message.…The value doesn't match the data validation restrictions.…Not sure about that one.…Come back to that later.…The residency code for this first person here…should be a six.…Type a six, press Enter,…and there's some restriction there that I don't know about…preventing me from putting that in.…Or I'm changing the compensation amount for this person,…133,000.…That's not acceptable either.…
Skill Level Appropriate for all
Q: Why can't I earn a Certificate of Completion for this course?
A: We publish a new tutorial or tutorials for this course on a regular basis. We are unable to offer a Certificate of Completion because it is an ever-evolving course that is not designed to be completed. Check back often for new movies.
Excel Tips - New This Week
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.