I have an excel sheet that requires my employees to enter their name and another formula that counts their name.
I would like to ensure that they use the same format when entering their name so that the count works accurately.
Is there a way of specifying what can be entered into a cell by limiting it to 3 or 4 values. I.e. only John, Jack, Jane and Jody can be entered and not anything else or variation of these?
Hi,
Take a look here
http://www.contextures.com/xlDataVal01.html
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
Yes its possible...
You can check Data Validation topic on excel ..
Below is a very simplified example
Select the range where u want to implement this validation.
Click on Data --> Validation
In the Data Validation Window
In Allow Drop Down .. Select "LIST"
and in Source enter the names separated by comma
eg. a , b , c , d
now type anything apart from a , b , c , d in the cell it wont accept
Shijesh Kumar
http://shijesh.wordpress.com/
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks