Share via

Limiting Excel Drop Down List

Anonymous
2018-03-22T16:22:23+00:00

I have created a drop down list for voting. There are ~400 choices, but I want to limit the voters to ten selections, and each selection must be unique.

I'm not sure that is clear ...

Here are the rules:

  1. Once a voter selects "NUMBER TEN" I want to ensure he/she can not select another choice as "NUMBER TEN"
  2. A voter cannot vote for more than ten options

(That is, one vote for number one; one vote for number two, etc.)

Can I do this in Excel?

Thanks.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Vijay A. Verma 104.9K Reputation points Volunteer Moderator
    2018-03-22T16:48:03+00:00

    This item might not exist or is no longer available

    Was this answer helpful?

    0 comments
  2. Anonymous
    2018-03-22T16:46:54+00:00

    Was this answer helpful?

    0 comments
  3. Vijay A. Verma 104.9K Reputation points Volunteer Moderator
    2018-03-22T16:23:29+00:00

    I need to have a look on your workbook to provide you the solution specific to your problem.

    Request you to please prepare and upload a sample / dummy file sans confidential / sensitive data to Onedrive and share the link? It will help me to give prompt and right solution.

    Was this answer helpful?

    0 comments