Excel help - dynamic dropdown lists
Discussion
Table with all your staff in, then a second table with an IF statement that returns a blank if the name is in your rota table, then a pivot table based on the second table that is used as the range for your drop-down.
Not sure if that'll work, but it's where I'd start. I think it'll drop all the blanks to the bottom of your drop-down as they're used.
Not sure if that'll work, but it's where I'd start. I think it'll drop all the blanks to the bottom of your drop-down as they're used.
tribbles said:
I can't think of a way either.
How about highlighting the colour if you've got two assigned?
Mind you, not sure on that one either! Can think of a kludgy way to do it...
That's really easy .... highlight the range which needs to be checked and use "conditional formatting" , "highlight cells rules", "duplicate values" then choose how you want to format any duplicates :How about highlighting the colour if you've got two assigned?
Mind you, not sure on that one either! Can think of a kludgy way to do it...
OP - what you want to do is possible, everything you need to know is here (including sample files) :
https://www.contextures.com/xlDataVal03.html
https://www.contextures.com/xlDataVal03.html
Gassing Station | Computers, Gadgets & Stuff | Top of Page | What's New | My Stuff