I have a problem with data validation drop down boxes.
I have a list of names in cells A1:A10. I have defined these with the name 'names'
I have created 5 drop down boxes using data validation, each referencing the defined name 'names', so each drop down box gives the option to select one of the 10 names from A1:A10.
What I want to do is once a name is selected in the first drop down box, it gets removed from the list 'names' so that the 2nd list only contains 9 items (A1:A10 minus the one selected in the 1st drop down box), the 3rd list only contains 8 items, etc.
Anyone know an easy way to do this? Thanks!
I have a list of names in cells A1:A10. I have defined these with the name 'names'
I have created 5 drop down boxes using data validation, each referencing the defined name 'names', so each drop down box gives the option to select one of the 10 names from A1:A10.
What I want to do is once a name is selected in the first drop down box, it gets removed from the list 'names' so that the 2nd list only contains 9 items (A1:A10 minus the one selected in the 1st drop down box), the 3rd list only contains 8 items, etc.
Anyone know an easy way to do this? Thanks!