Hi Debra. Learned this method from Mike Girvin today: =FILTER(tblEmp[EmpList],ISNA(XMATCH(tblEmp[EmpList],tblSched[Employee]))). Sharing it here for anyone interesting in another method. Thumbs up!!
Really Thanks so much This problem was confusing me and I hoped to find the solution. The problem is the version, but I follow your guidelines. Thanks again
You're welcome, Mohamed, and thanks for your comment! There are formulas for earlier versions of Excel on my Contextures site: www.contextures.com/xlDataVal03.html
@@contextures no problem at all. always happy to support my fellow content creators. i am looking forward to improving on my own current video format i have uploaded and, in the future, trying to create content as good as yours in the long term.
Hi Debra, Thank you for the video. Can we have such drop down list in which first half values are allowed to select multiple times and remaining values are allowed to select once? I hope you can help me
Hello Debra. Thank you for sharing this. This trick is working but I get errors from the data validation. (Restriction: Value must match one of the listed items). Is there a way to fix this problem without just ignoring them. I am working with the 2021 version. Thank you in advance.
Thanks, Richard, and you could try a variation on my "Latest Items at Top" example. Modify the formula so the unused items are at the top, with used items below. That way, every item is in the list, and valid www.contextures.com/exceldropdownlatestitemstop.html
@@contextures Thank you so much for your quick reply. Ill try to make it work with the example you gave. I don't have much experience with formulas like those, but I will give it a try. Have a wonderful Sunday.
@@cyruzpapyruz Thanks, Richard, and try this formula to create the list of names: =SORTBY(SORT(tblEmp[EmpList]),tblEmp[Used],1) I've added a new section on my Hide Used Items page, and a sample file: www.contextures.com/xlDataVal03.html#dverror
Thanks for the great video! I need to search for matches in multiple locations (i.e. multiple tblSched employee), how would I make this work? Thank you! :)
If i want to repeat this multiple times with the same list over a document, roughtly 100 times, is there another way to do this without having a "Not Used" list for every list?
Welcome back to "Debra". We are missing your tips and tricks. I am so happy for your comeback to RUclips
Thank you, Sameh, and I'm glad to be back!
Hi Debra. Learned this method from Mike Girvin today: =FILTER(tblEmp[EmpList],ISNA(XMATCH(tblEmp[EmpList],tblSched[Employee]))). Sharing it here for anyone interesting in another method. Thumbs up!!
Really
Thanks so much
This problem was confusing me and I hoped to find the solution.
The problem is the version, but I follow your guidelines.
Thanks again
You're welcome, Mohamed, and thanks for your comment! There are formulas for earlier versions of Excel on my Contextures site:
www.contextures.com/xlDataVal03.html
fabulous upload Contextures Inc.. I broke that thumbs up on your video. Keep on up the amazing work.
Thank you so much! I appreciate your support, and hope your thumb feels better soon 👍 😉
@@contextures no problem at all. always happy to support my fellow content creators. i am looking forward to improving on my own current video format i have uploaded and, in the future, trying to create content as good as yours in the long term.
hello, I'm a bit new to excel, and this video is kinda advanced for me, what do you think i should learn before watching this one??
Thanks for asking, and you could start with the videos in my playlist for Excel Key Skills
ruclips.net/p/PLHsqxd7luqCWhvMkwu2oG9ms21fepmbBr
Yay you’re back Time for learning
Thanks, Patrick! It's good to be back again, and thanks for your long-time support!
Thanks for sharing
You're welcome, and thanks for your comment!
I can get this to work on a PC, but I use excel on my mac and it will not work. Any ideas how to do this on a mac?
Thanks for asking, John, but I don't have an answer for you. There's a Mac Excel forum on the Microsoft site, where someone might be able to help you
Hi Debra. An awesome trick! Thanks for sharing :)) Thumbs up!!
Thanks so much, Wayne! This trick is much easier now, with the new SORT and FILTER functions
@@contextures Agreed! Most definitely :))
Hi Debra,
Thank you for the video.
Can we have such drop down list in which first half values are allowed to select multiple times and remaining values are allowed to select once?
I hope you can help me
Got Solution🙂
You're welcome, Subhash, and thanks for letting me know that you found a solution for your question!
I need help with this!
I need help doing this in Google Sheets! this Data Validation doesn't work in google sheets :(
Hey @contextures,
I need help doing this in Google sheets .
Thanks, but I don't have any Google Sheets videos
Hello Debra. Thank you for sharing this. This trick is working but I get errors from the data validation. (Restriction: Value must match one of the listed items). Is there a way to fix this problem without just ignoring them. I am working with the 2021 version. Thank you in advance.
Thanks, Richard, and you could try a variation on my "Latest Items at Top" example. Modify the formula so the unused items are at the top, with used items below. That way, every item is in the list, and valid
www.contextures.com/exceldropdownlatestitemstop.html
@@contextures Thank you so much for your quick reply. Ill try to make it work with the example you gave. I don't have much experience with formulas like those, but I will give it a try. Have a wonderful Sunday.
@@cyruzpapyruz Thanks, Richard, and try this formula to create the list of names: =SORTBY(SORT(tblEmp[EmpList]),tblEmp[Used],1)
I've added a new section on my Hide Used Items page, and a sample file:
www.contextures.com/xlDataVal03.html#dverror
Thanks for the great video! I need to search for matches in multiple locations (i.e. multiple tblSched employee), how would I make this work? Thank you! :)
If i want to repeat this multiple times with the same list over a document, roughtly 100 times, is there another way to do this without having a "Not Used" list for every list?
Perhaps, with event code and macros, but I don't have an example for you
Hi. I have a situation with a 3 persons with a same name. If I select one name, there all 3 dissapears. Do you have a solution with this case? Thanks.
Could you add an initial, or a number, at the end of each duplicate name, to make them unique?
@@contextures Yes, I know, this resolves the problem. But is it a way to resolve this kind of problem with formula?
Anyway you can for multiple columns?
There's an example on my website that hides used items across a row. Maybe that would help you
www.contextures.com/xlDataVal03.html#other