Excel Reducing Data Validation List

As you select items from the data validation list (drop down list) they are no longer available to select in further cells.

Download the Excel file and step by step instructions here:

Thanks to MF Wong for the original solution which I've modified in this video. You can see his example here:

Excel,drop down lists,data validation,Excel Data Validation,Excel Drop Down Lists,