Hi
On my spreadsheet I am using a list of names (called Names), these are used in a drop down list. What I want is that when a name on the list has been used in 1 column then it can no longer be selected again for that column, but can be selected in another column.
Any ideas?
Cheers
On my spreadsheet I am using a list of names (called Names), these are used in a drop down list. What I want is that when a name on the list has been used in 1 column then it can no longer be selected again for that column, but can be selected in another column.
Any ideas?
Cheers