Easily the simplest method I have seen to achieve this required validation. Excellently explained without all the usual bumf and constant repetition you get on these videos👍. A question though, how do you prevent one of the list from ever hiding when selected, like a permanent piece of data for the list?
By far the simplest and most efficient method to prevent duplicate selections from a list of several hundred unique choices. In my case assigning hundreds of phone numbers to users across multiple branches, and ensuring the correct phone number is allocated per branch. while ensuring that same phone number is not assigned to multiple staff, I use a combination of protected sheets & locked cells (for those staff that just type, delete, copy, paste and insert columns & rows and mess up all the formulas & formatting). I love the fact that you added in the table method and I used it in combination with Named ranges.
This worked great on my PC, but when I opened it in excel on my MacBook pro it did not work. The formula changed. When I tried to type it back it, I get errors. The data validation does not work wither. There is nothing in the drop down now. any ideas on how to make this work for excel using a mac?
What do I do if I have a name list with 12 names and want to distribute them into two lists. Example; I have 12 players in a basketball team and want to make two substitutions in one period. That is, 10 players on two lists, of which 2 players remain. You have one list "assigned to", but I want two lists.
This is a short but very detailed 👌 👍 👏
Easily the simplest method I have seen to achieve this required validation. Excellently explained without all the usual bumf and constant repetition you get on these videos👍. A question though, how do you prevent one of the list from ever hiding when selected, like a permanent piece of data for the list?
This has to be one of the most well made teaching videos I have seen.
By far the simplest and most efficient method to prevent duplicate selections from a list of several hundred unique choices.
In my case assigning hundreds of phone numbers to users across multiple branches, and ensuring the correct phone number is allocated per branch. while ensuring that same phone number is not assigned to multiple staff, I use a combination of protected sheets & locked cells (for those staff that just type, delete, copy, paste and insert columns & rows and mess up all the formulas & formatting). I love the fact that you added in the table method and I used it in combination with Named ranges.
Thanks for this! This really helped me simplify my fantasy hockey draftboard.
Very valuable content well explained and kept brief. Thanks
So, I'm an excel idiot is what this tells me. Very valuable insight for someone trying to learn more about Excel
Yeap! Excellent logic to solve this case. Thank you Chester!!!
That is just brilliant ! Thanks for this excellent tutorial
This worked great on my PC, but when I opened it in excel on my MacBook pro it did not work. The formula changed. When I tried to type it back it, I get errors. The data validation does not work wither. There is nothing in the drop down now. any ideas on how to make this work for excel using a mac?
How can I use this formula across multiple sheets , I try it and didn’t work out
Damn, you're good!
Thanks for this - any idea if this would work in google sheets?
I'm using the 2016 version of Excel and there's no Filter function. Any suggestions? Well made tutorial otherwise.
Another masterpiece ✨️ 👏
Is there a way to make this work across multiple columns and rows?
You are epic!
How can I do this on multiple sheets instead of one?
What if the dropdowns are not adjacent to each other?
What do I do if I have a name list with 12 names and want to distribute them into two lists.
Example; I have 12 players in a basketball team and want to make two substitutions in one period. That is, 10 players on two lists, of which 2 players remain.
You have one list "assigned to", but I want two lists.