Hello,
I am trying to came up with a way to have a Data Validated Drop Down Cell which would allow selection from a LIST but only allow the values witch contain all upper cases and numbers with upper case text, example:
addda <--Do Not Allow in validated drop down
AGBGDD <--Allow in validated drop down
5060 AUOOOK <--Allow in validated drop down
5089 <--Do Not Allow in validated drop down
7890 rtoiegg <--Do Not Allow in validated drop down
Is this possible?
Thanks
Hi plans,
This sounds like a job for an Advanced Filter. I'd bet if you look at the Code of the first letter of each cell and only filter ones with code below 97, you would get close to what you are asking for.
If you supply a sample workbook it would be easy to show you what I mean.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
MarvinP,
See attached file.
Thanks for the help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks