Hi All
I have a drop-down list in data validation which links to a dynamic named range. However, I also want to add another option in the drop-down list "N/A". I don't want this option in the dynamic named range, because the "N/A" option only applies to this particular drop down list. Is there a formula I can type into the source box in the Data Validation menu to allow this?
I've tried
but Excel doesn't like that.
OrganisationListSort is the dynamic named range
I have a drop-down list in data validation which links to a dynamic named range. However, I also want to add another option in the drop-down list "N/A". I don't want this option in the dynamic named range, because the "N/A" option only applies to this particular drop down list. Is there a formula I can type into the source box in the Data Validation menu to allow this?
I've tried
Excel Formula:
=OrganisationListSort,"N/A"
OrganisationListSort is the dynamic named range