Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-12-2015, 02:20 AM
Officer_Bierschnitt Officer_Bierschnitt is offline Data validation the other way round? Windows 7 64bit Data validation the other way round? Office 2013
Advanced Beginner
Data validation the other way round?
 
Join Date: Oct 2015
Posts: 79
Officer_Bierschnitt is on a distinguished road
Default Data validation the other way round?

Hi,

there is a list where employees enter data about internal damages done by forklifts.
In this, there is a column where they are to enter a name if it is sure who was driving - if not, they are to just leave it empty.


There are experts, however, who write something like "known" or "unknown" or whatever in that column.

=> Thus my question: Can I implement some kind of data_validation so that people can only enter some real name, maybe based on the criterion that a real name has 2 or more segments? (I don't know what else could be the criterion, but any ideas are welcome).

Thanks a lot!
Best regards,

Officer_Bierschnitt
Reply With Quote
  #2  
Old 11-12-2015, 07:01 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Data validation the other way round? Windows 7 64bit Data validation the other way round? Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,748
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Perhaps check the following link http://www.contextures.com/xlDataVal01.html
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #3  
Old 11-12-2015, 07:57 AM
Officer_Bierschnitt Officer_Bierschnitt is offline Data validation the other way round? Windows 7 64bit Data validation the other way round? Office 2013
Advanced Beginner
Data validation the other way round?
 
Join Date: Oct 2015
Posts: 79
Officer_Bierschnitt is on a distinguished road
Default

Hi,

there is nothing on that page that I can use. I can neither create a list of the names of all the employees in the company - well, I could, but that would be quite an effort - nor can I create a list of the entries that I do not want, the creativity of the people out there is endless

But then - a list of all the people drawn from our HR_system is probably the only good solution because even if I could implement a rule that an entry must have 2 or more segments, they would sometimes only write the surname or write it all in one go (no BLANKs) or whatever.

Thanks a lot!
Best regards,

Officer_Bierschnitt
Reply With Quote
  #4  
Old 11-13-2015, 10:12 PM
Peter_SSs Peter_SSs is offline Data validation the other way round? Windows 7 64bit Data validation the other way round? Office 2010 32bit
Novice
 
Join Date: Nov 2015
Location: Macksville, Australia
Posts: 1
Peter_SSs is on a distinguished road
Default

Quote:
Originally Posted by Officer_Bierschnitt View Post
Can I implement some kind of data_validation so that people can only enter some real name, maybe based on the criterion that a real name has 2 or more segments?
To do that, and say the cell with the Data validation is cell A1, then in the DV dialog -> Settings tab -> Allow: Custom -> Formula: =FIND(" ",A1)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Paste over data validation saurabhlotankar Excel Programming 2 05-24-2015 11:52 PM
Data validation the other way round? data validation from another sheet paulys Excel 1 06-30-2014 01:40 AM
Data validation the other way round? Data Validation drop down rkalapura Excel 1 05-27-2012 02:23 AM
If/then formulas with data validation shira47 Excel 1 04-09-2012 05:14 AM
Data validation with IF Klyxrastafari Excel 1 10-03-2011 04:41 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:30 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft