J
John Jost
I am working on a cell validation formula (Data, Validation) where I provide
a list from a specified range. My list will have 10 choices. The form will
have three separate validation cells from which they will select their first,
second and third choices. As all three cells will show choices A-J, I want
to make sure they do no select the same option multiple times.
Can my lists that contain the same range, only contain the unselected values
from the other list boxes? For Example box one the user selects “Aâ€, box two
should show options B-J. Option Box two, the user selects “Bâ€, then box
three should not show “A†or “Bâ€.
Can this be done?
a list from a specified range. My list will have 10 choices. The form will
have three separate validation cells from which they will select their first,
second and third choices. As all three cells will show choices A-J, I want
to make sure they do no select the same option multiple times.
Can my lists that contain the same range, only contain the unselected values
from the other list boxes? For Example box one the user selects “Aâ€, box two
should show options B-J. Option Box two, the user selects “Bâ€, then box
three should not show “A†or “Bâ€.
Can this be done?