Hi, Excel Experts. My name is Rick and I am a project manager at a telecommunications firm in the United States of America.
I have a problem that I have been trying to solve for several months, but I am no closer to a solution than I was in October 2013. I have a spreadsheet in which I need to...
Is there a way to set up Data Validation so that each item in the Data Validation list drop-down cannot be selected more than once? For instance, with the following list:
Drop
Down
Box
Both
Once
If I select Down, then Down will not be an available choice for any of the other cells in the...