Data Validation Question?

  • Thread starter Thread starter mastermind
  • Start date Start date
M

mastermind

I need to limit the data entered into a cell to be either: 1, E, e, A,
or a. Can someone tell me the custom formula I would need, to achieve
this result? Thank you.
 
Data/ Validation/ Allow: List, and in source include: 1, E, e, A
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

custom data validation on cells with data validation values 2
If formula and Data Validation parallely 1
Data Validation Question 1
Multiple data validation criteria? 1
Data validation for specific text, for example "blue"? 1
Need help with Data Validation Formula for a set of numerical andtext-based values 7
SUMIF with criteria "<>" & "=" 4
how to do data validation in excel 1

Back
Top