I am wondering if it is possible to have the choices from a drop box eliminated after they have been selected.
Any help is appreciated.
I am wondering if it is possible to have the choices from a drop box eliminated after they have been selected.
Any help is appreciated.
what do you mean by eliminated? from where? the original list from the dropdown box? a new list for a new dropdown box? some other range of data?
When I say semicolon, u say comma!
What I am wanting is once one of the choices is made from the drop list it cannot be used a second time. For example if my drop list contained 3 choices A B and C, once A was selected only B and C would remain in the drop list. I am also curious if it is possible to activate the mouse scroll wheel to use in the drop list to aid in making selections.
Thank you for your interest.
If list range is A1:A3 and drowdownbox is in B1, use this:
A1: =IF(B1="A","","A")
A2: =IF(B1="B","","B")
A3: =IF(B1="C","","C")
So that once you select one of the values in the dropdown, the one in the list goes empty.
Don't know about the scroll wheel
I have attached the sheet for you to look at. The drop list was created off the teams sheet.
Thank you for your help.
In the attachment is your file back with my solution.
All I've done is change the options list in the Teams sheet by putting a formula around every value, that sais: "if you already find this value in the other sheet, don't show it here".
So when you fill in one of the dropdowns, the value will appear empty in all the other dropdowns. This does create empty rules in your dropdown lists, which is not the prettiest sight, but it works If you want those empty lines to also disappear from the list, it would take a lot more work (for as far as I know), but it can be done if you like.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks