Can I pick more than 1 entry in the validation function?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using the validation function for data. Using the pull down function.
In some instances, they will have to pick 2 or more answers from the list.
Right now it only lets you pick one. How do I allow it to pick 2 or more?
 
Dora said:
I am using the validation function for data. Using the pull down function.
In some instances, they will have to pick 2 or more answers from the list.
Right now it only lets you pick one. How do I allow it to pick 2 or more?
Click to expand...

Hi Dora

An Excel cell can only have one "value".

Unless you have all possible answer combinations to your validation
list (e.g. "answer1 and answer2", "answer1 and answer3", "answer2 and
answer3"), you'll need to put the second answer in another cell.

Regards

Steve
 

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

Vlookups not working 2
Validation & Muliple List Picks 2
Match - not sure how to use this function 3
Data Validation Combine Functions 2
How do I create a drop down box within a drop down box? 1
Help to pick string value if match happens 1
Excel 2007 / right-click / pick from drop down list 1
VLookup not working - missing entries or not returning correct values 1

Back
Top