Forum Discussion
Options in drop down lists
Hello. I am working on a spreadsheet with 3 columns that have drop down lists containing the same words.
apple
orange
grape
is it possible to have it so that if I choose apple from column 1 it will disappear from column 2
i am not sure if I am explaining itself correctly or if this is doable. Thank you.
2 Replies
See Hide Used Items in Drop Down List
Relevant sample workbook near the bottom: Single Task dynamic under Hide Used Selections Across a Row.
