Excel Data Validation List multiple choice WITHOUT using VBA

dtbsmith 

1. Create a constant for your list and bank in the name manager:

'colors

={"red";"green";"blue";"yellow";"purple"}

2. Refer to the named item in the sheet creating a spill.

=colors

3. Create a 'remaining' spill by identifying what has been selected:

Selections being the range with your data validation menus.

=FILTER(G4#,ISERROR((XMATCH(G4#,Selections))))

4. Point the first cell  with data validation to the colors spill where all choices are available.

e.g.  =$G$4#

Point subsequent data validation lists to the remaining spill.

e.g. =$H$4#

5. Enjoy