Drop-down menu

%3CLINGO-SUB%20id%3D%22lingo-sub-2747790%22%20slang%3D%22en-US%22%3EDrop-down%20menu%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2747790%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3ESorry%20I%20am%20a%20really%20novice%20user%20of%20excel.%20%26nbsp%3BI%20am%20trying%20to%20create%20a%20template%20with%20dropdown%20lists%20to%20help%20write%20a%20daily%20roster.%20%26nbsp%3BIs%20there%20any%20way%20you%20can%20link%20the%20drop-down%20lists%20in%20a%20column%20and%20or%20row%20such%20that%20the%20item%20is%20then%20removed%20from%20the%20other%20lists%3F%3C%2FP%3E%3CP%3EFor%20example%20in%20rostering%20people%3A%20if%20the%20main%20drop%20down%20list%20has%20all%20the%20available%20people%20for%20the%20day%2C%20but%20then%20once%20I%20put%20someone%20on%20checkout%2C%20I%20would%20like%20them%20removed%20from%20the%20option%20of%20supervisor.%20%26nbsp%3BIf%20I%20then%20later%20made%20changes%20and%20removed%20them%20from%20the%20checkout%2C%20would%20they%20reappear%20as%20an%20option%20for%20supervisor%3F%20%26nbsp%3Bthanks%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2747790%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2750123%22%20slang%3D%22en-US%22%3ERe%3A%20Drop-down%20menu%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2750123%22%20slang%3D%22en-US%22%3EIt%20is%20possible.%20We%20would%20like%20your%20assistance%20by%20providing%20some%20sample%20data.%3CBR%20%2F%3EThe%20idea%20behind%20is%20check%20if%20someone%20was%20selected%20on%20your%20dropdown%20list%2C%20if%20so%2C%20then%20the%20formula%20will%20return%2C%20for%20instance%2C%20a%20blank%20value%2C%20simulating%20a%20%22removal%22%20from%20availability.%3C%2FLINGO-BODY%3E
New Contributor

Hi

Sorry I am a really novice user of excel.  I am trying to create a template with dropdown lists to help write a daily roster.  Is there any way you can link the drop-down lists in a column and or row such that the item is then removed from the other lists?

For example in rostering people: if the main drop down list has all the available people for the day, but then once I put someone on checkout, I would like them removed from the option of supervisor.  If I then later made changes and removed them from the checkout, would they reappear as an option for supervisor?  thanks 

1 Reply
It is possible. We would like your assistance by providing some sample data.
The idea behind is check if someone was selected on your dropdown list, if so, then the formula will return, for instance, a blank value, simulating a "removal" from availability.