Microsoft Excel ??? - Techist - Tech Forum

Go Back   Techist - Tech Forum > Computer Software > Microsoft Windows and Software
Click Here to Login
Closed Thread
 
Thread Tools Display Modes
 
Old 12-21-2005, 04:37 PM   #1 (permalink)
Junior Techie
 
Join Date: Jun 2005
Posts: 48
Send a message via Yahoo to j4mes_bond25
Question Microsoft Excel ???

Does anyone know, if I can set a validation in Excel in the way, that say, Row A already has data typed in it but when someone opens the file, they can't see the text of Row A (or a particular cell), but can type in it & IF only they type the same text which is already in there (i.e. within a cell, however, invisible to them) can they SEE the text, after they press Enter (bringing the squared cursor to the next cell).

If the typed information doesn't match with what's in that particular cell, then it should remain blank, so he/she would know that information typed is incorrect i.e. doesn't match with what's already in there.
__________________

j4mes_bond25 is offline  
Old 12-21-2005, 04:49 PM   #2 (permalink)
Techie Beyond Description
 
Osiris's Avatar
 
Join Date: Jan 2005
Location: Kentucky
Posts: 36,817
Send a message via ICQ to Osiris Send a message via AIM to Osiris Send a message via MSN to Osiris Send a message via Yahoo to Osiris
Default

I know what you are try to do but its complicated....its kinda like autofill or something...i havent messed with Excel in such a long time...im lookin thou
__________________

__________________
Osiris is offline  
Old 12-21-2005, 04:56 PM   #3 (permalink)
Junior Techie
 
Join Date: Jun 2005
Posts: 48
Send a message via Yahoo to j4mes_bond25
Default Warez Monster !!!

Quote:
Originally posted by Warez Monster
I know what you are try to do but its complicated....its kinda like autofill or something...i havent messed with Excel in such a long time...im lookin thou
I would really appreciated, if you could help me the best possibly way you could.
j4mes_bond25 is offline  
Old 12-21-2005, 05:42 PM   #4 (permalink)
It's all just 1s and 0s
 
office politics's Avatar
 
Join Date: Jan 2004
Location: in the lab
Posts: 6,555
Send a message via MSN to office politics
Default

data | validate, i believe
office politics is offline  
Old 12-22-2005, 04:54 AM   #5 (permalink)
Junior Techie
 
Join Date: Jun 2005
Posts: 48
Send a message via Yahoo to j4mes_bond25
Default

Quote:
Originally posted by csamuels
data | validate, i believe
As you can see from the attachment, that I'm probably using the right command i.e. Data > Validation, however, all I could do is simply set the length of the text. So, if someone types in "drink" in the cell "drink coffee", that will show NO error, since the word "drink" in itself has 5 character of text length.

However, what I rather wanted was a way excel "identifies" the text within the cell in the way that if, it doesn't get typed the way it's in there i.e. if someone doesn't type the exact "drink coffee" then, it should show the error.
Attached Images
File Type: jpg datavalidation.jpg (42.7 KB, 24 views)
__________________
Nope, I\'m NOT God, but I\'m British (which is the next best thing) ;)
j4mes_bond25 is offline  
Old 12-22-2005, 04:42 PM   #6 (permalink)
It's all just 1s and 0s
 
office politics's Avatar
 
Join Date: Jan 2004
Location: in the lab
Posts: 6,555
Send a message via MSN to office politics
Default

http://techrepublic.com.com/5100-1035_11-1033361.html#

specify allow list, create a list of valid entries in your spreadsheet, then in settings assign the list you just created. goto error alert to specify an error message when invalid input is entered.

this will also create a drop down list for your users to choose from.
office politics is offline  
Old 12-23-2005, 04:50 AM   #7 (permalink)
Junior Techie
 
Join Date: Jun 2005
Posts: 48
Send a message via Yahoo to j4mes_bond25
Default csamuels !!!

Quote:
Originally posted by csamuels
http://techrepublic.com.com/5100-1035_11-1033361.html#

specify allow list, create a list of valid entries in your spreadsheet, then in settings assign the list you just created. goto error alert to specify an error message when invalid input is entered.

this will also create a drop down list for your users to choose from.
Thanks very much for taking your time out in helping me out here & is much appreciated.

This was simply a stellar. It did the job, exactly the way I wanted & can apply it on my spreadsheet, however, this time, I simply will have to add additional column for the "list" & then can hide the column, so whoever types it won't be able to see what the input is meant to be, unless he/she knows it beforehand.

This was my very first post on this website, which I came across while browsing the net & as THEY say, a satisfied customer always comes back. So, I'll be around on this forums, from now onwards.
__________________
Nope, I\'m NOT God, but I\'m British (which is the next best thing) ;)
j4mes_bond25 is offline  
Old 12-23-2005, 12:07 PM   #8 (permalink)
It's all just 1s and 0s
 
office politics's Avatar
 
Join Date: Jan 2004
Location: in the lab
Posts: 6,555
Send a message via MSN to office politics
Default

ha, yea. thats how it started for me. 2000 posts later, im scrambling around trying to help ppl. I hope you enjoy your stay at TF. It is a good crowd.
__________________

office politics is offline  
Closed Thread

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off




Copyright 2002- Social Knowledge, LLC All Rights Reserved.

All times are GMT -5. The time now is 08:32 AM.


Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2017, vBulletin Solutions, Inc.