Hi there,
I have created a spreadsheet for units for a Diploma that assessors can use to select various units from a number of possible options. I have put in a data validation into the cells so that the only option that can be selected is "unit selected", or they can leave it blank if that particular unit is not being selected.
Because there are some units that are incompatible with others, I wanted to know if there was a way of preventing the incompatible unit being selected if the assessor had already chosen a unit which would be incompatible with the second unit they are wanting to select. i.e. Unit CMM01 is incompatible with unit BVF5, if the assessor has used the dropdown menu for unit CMM01 and chosen "unit selected", is there a way that I can remove the option of unit BVF5 being selected also?
I hope that makes sense?
Thank you in advance for your help!
Tess