Share via

Help with showing specific questions after selecting a specific item in a drop-down list.

Anonymous
2024-12-12T16:59:38+00:00

I need to do two things in Excel.

(1) I need to have a set of questions appear when selecting a certain item in a drop down list. (E.g. The list says 1st semester, 2nd semester, 3rd semester, 4th semester with three rows of questions below each. So if selecting 1st semester, three questions relating to a that will show, etc.). Questions will be filled in by user, example, what challenges did you face in the 3rd semester?

(2) I need to keep the data that is filled in for those 1st semester questions when selecting 2nd, 3rd, or 4th so people can see historical data. Is this possible? I am not an Excel expert so laymens terms please.

Microsoft 365 and Office | Excel | For education | Other

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

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Ashish Mathur 100.8K Reputation points Volunteer Moderator
    2024-12-12T23:53:57+00:00

    Hi,

    For the 1st question, you should be able to use the FILTER() function. To receive specific help, share some data to work with and show the expected result.

    0 comments