Single selection from drop down box

%3CLINGO-SUB%20id%3D%22lingo-sub-1873853%22%20slang%3D%22en-US%22%3ESingle%20selection%20from%20drop%20down%20box%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1873853%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20creating%20a%20drop%20down%20list%20but%20the%20options%20are%20rather%20extensive%3B%20is%20there%20a%20way%20to%20make%20it%20so%20once%20someone%20chooses%20an%20item%20from%20my%20drop%20down%20menu%20that%20the%20item%20won't%20reappear%20in%20the%20next%20line%3F%26nbsp%3B%20For%20example%20if%20I'm%20doing%20cities%20within%20Colorado%20and%20someone%20opens%20the%20dropdown%20menu%20on%20line%201%20and%20chooses%20%22Denver%22%20I%20don't%20want%20them%20to%20be%20able%20to%20chose%20Denver%20again%20on%20line%202.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1873853%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1873947%22%20slang%3D%22en-US%22%3ERe%3A%20Single%20selection%20from%20drop%20down%20box%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1873947%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F864487%22%20target%3D%22_blank%22%3E%40phild80017%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESee%20%3CA%20href%3D%22https%3A%2F%2Fwww.contextures.com%2FxlDataVal03.html%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3EHide%20Used%20Items%20in%20Drop%20Down%20List%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

I'm creating a drop down list but the options are rather extensive; is there a way to make it so once someone chooses an item from my drop down menu that the item won't reappear in the next line?  For example if I'm doing cities within Colorado and someone opens the dropdown menu on line 1 and chooses "Denver" I don't want them to be able to chose Denver again on line 2. 

1 Reply
Highlighted