Is this an Excel BUG?

FH frank ho 0 Reputation points

Hi, First, Set A1="Male", A2="Female" in an Excel sheet and name "Sex=$A$1:$A$3".

  1. In the data validation dialog box for B1, specify "Allow"="Sequence", "Source"="=Sex". Then enter "Any" in B1 can pass the data validation.
  2. However, if you specify "Source" = "=$A$1:$A$3" in the data validation dialog box of B1, the data validation cannot be passed when you enter "Any" in B1.
  3. This is not the case for "Sex=$A$1:$A$2".


A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,291 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Emi Zhang-MSFT 20,106 Reputation points Microsoft Vendor


    I can reproduce this behavior in Excel, it seems this is by design behavior.

    If you have any feedback or suggestion about this behavior, you can try to give a feedback to Microsoft about your requirement:

    Microsoft values your opinion. Your feedback goes directly to our engineers and helps us shape the future of Microsoft products and services for all our users.

    If the response is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments