Good morning,
I am setting up an excel file where users must select "X" from a dropdown menu to rate their proficiency in certain software programs as beginner, intermediate or advanced. The file is set up such that the software programs are listed in column format (cells A1 through A12) and the beginner/intermediate/advanced selections take place per row using drop down menus.
I would like to prevent users from selecting an "X" in multiple categories, i.e a user cannot select an "X" to say that they are both beginner and intermediate proficiency for the same software program.
I would like an error message to pop up if a user attempts to select an "X" from the drop down menu if they have already selected an "X" somewhere in the same row. I thought of using a nested IF function but I cannot seem to get it to work correctly.
Any advice?
Thank you!
I am setting up an excel file where users must select "X" from a dropdown menu to rate their proficiency in certain software programs as beginner, intermediate or advanced. The file is set up such that the software programs are listed in column format (cells A1 through A12) and the beginner/intermediate/advanced selections take place per row using drop down menus.
I would like to prevent users from selecting an "X" in multiple categories, i.e a user cannot select an "X" to say that they are both beginner and intermediate proficiency for the same software program.
I would like an error message to pop up if a user attempts to select an "X" from the drop down menu if they have already selected an "X" somewhere in the same row. I thought of using a nested IF function but I cannot seem to get it to work correctly.
Any advice?
Thank you!
