Fantastic video........I am not very good with excel. But I was able to make it work after about 2 hours of watching the video and working with the formula alongside. Thank you so much.
This is excellent thank you! Do you know how to modify it so we could have the same pull down list in multiple columns? That is, each column would only hide those names already picked for that column and be independent of the other columns? Cheers
hi doug, i have been searching a very long time for something like this! can you imagine how lucky i feel right now. i did find something similar from Ajay Anand, but he used one of the new office 365 functions, FILTER, which i do not have... once again, many thanks!
@DougHExcel I know it's been a while but is there a better way to do this that doesn't rely on the data to be in the first row of a sheet? Can this be done when the data being referenced begins at row 68 for example?
first of all, in the sheet "source", can it mark which ones are already taken? second, assuming that instead of a text, they are numbers, and whenever i used the selection, can it add up all the selection that i made ? thanks.
Doug H can we try =if(countifs($a$1:$a$100,a1)>=1,"",max($a$1:a1)+1) And use at column c =iferror(index(a:a,match(row(a1),b:b,0),"") Or is there something wrong with it
Hello! Great vid. Do you have an idea of how I can do the following: I have a list of teams (1-10), I want to choose a time for them (Drop down menu with time increments of 15minutes) ex. "Monday 10:00 AM", "Monday 10:15 AM", "Monday 10:30 AM", etc., When I select a time for a team I not only want that time to disappear, I want that time plus 1 hour to disappear. Ex. Team one chooses "Monday 10:00 AM", the next available time to choose would be "Monday 11:00 AM". Is this possible? Thanks in advance.
off the top of head...create a list of the Day Time entries as string/text value, not date values as excel will see those dates as a number. Then implement this like the video example
A drop-down list with 10 names. in line 1 choose name number 1, in line 2 do not show name number 1 because it was selected before. continue like that until the end. can this be done?
Aggghh...though I think I've entered the correct formula (it would be easier if you could put the formulas in the description), it's not working. The first 3 columns look like yours, but when I type a name in the first sheet, the the cell shows formula error not blank - any ideas please?
ahh I haven't explored Google Forms, but if it is like other forms type applications, it should have a branching function where you'd manually select the list of outputs if someone made a selection. It could be tedious to set this all out.
traduction en excel 2016 français, les formules: attention: pour l'exemple de la video poser a2:a6 et b2:b6 à cause de l'entête. =SI(NB.SI(listederoulante;A1)>=1;"";LIGNE()) =SI(NB.SI(listederoulante;A2)>=1;"";LIGNE()) =SI(NB.SI(listederoulante;A3)>=1;"";LIGNE()).... =SI(LIGNE(A1)-LIGNE(A1)+1>NB(B1:B6);"";INDEX(A1:A6;PETITE.VALEUR(B1:B6;1+LIGNE(A1)-LIGNE(A1)))) =SI(LIGNE(A2)-LIGNE(A1)+1>NB(B1:B6);"";INDEX(A1:A6;PETITE.VALEUR(B1:B6;1+LIGNE(A2)-LIGNE(A1)))) =SI(LIGNE(A3)-LIGNE(A1)+1>NB(B1:B6);"";INDEX(A1:A6;PETITE.VALEUR(B1:B6;1+LIGNE(A3)-LIGNE(A1))))...
If this video didn't fit, there are some other Dropdown List video at ua-cam.com/play/PL-n8f1cY_Qw9-ZSEpRN3OLmzYp4w54vht.html
...
Fantastic video........I am not very good with excel. But I was able to make it work after about 2 hours of watching the video and working with the formula alongside. Thank you so much.
Great 👍👍👍
This is excellent thank you! Do you know how to modify it so we could have the same pull down list in multiple columns? That is, each column would only hide those names already picked for that column and be independent of the other columns?
Cheers
This was awesome, thank you for posting!
Glad you enjoyed it!
Thanks, Doug : ) Thanks Debra : )
Thanks Mike! Debra's got some great stuff at contextures.com!
ExcelIsFun i think using max and iferror with match might be easier
hi doug, i have been searching a very long time for something like this! can you imagine how lucky i feel right now. i did find something similar from
Ajay Anand, but he used one of the new office 365 functions, FILTER, which i do not have... once again, many thanks!
Glad I could help!
Can you do this across rows with columns separating the cells with the data validation list?
Thanks dude.. it really helped alot
Glad it helped!
Thanks for your sharing. It really help mea lot. If I can copy the formula somewhere else. It would be great!. Anyway, Great Job Doug H.
You’re welcome!
@DougHExcel I know it's been a while but is there a better way to do this that doesn't rely on the data to be in the first row of a sheet? Can this be done when the data being referenced begins at row 68 for example?
first of all, in the sheet "source", can it mark which ones are already taken? second, assuming that instead of a text, they are numbers, and whenever i used the selection, can it add up all the selection that i made ? thanks.
Can we make the filter searchable?
Not in this implementation, but another video that might give an idea on how to incorporate it in
ua-cam.com/video/zN0iYcEZJl0/v-deo.html
Amazing stuff
Hi ibrahim ezz, thanks for the comment!
Doug H can we try =if(countifs($a$1:$a$100,a1)>=1,"",max($a$1:a1)+1)
And use at column c =iferror(index(a:a,match(row(a1),b:b,0),"")
Or is there something wrong with it
very goooooood
Hi Pedro Cabral da Camara, thanks for the comment!
Bro it will be great if you can share this excel file
Hello! Great vid. Do you have an idea of how I can do the following: I have a list of teams (1-10), I want to choose a time for them (Drop down menu with time increments of 15minutes) ex. "Monday 10:00 AM", "Monday 10:15 AM", "Monday 10:30 AM", etc., When I select a time for a team I not only want that time to disappear, I want that time plus 1 hour to disappear. Ex. Team one chooses "Monday 10:00 AM", the next available time to choose would be "Monday 11:00 AM". Is this possible? Thanks in advance.
off the top of head...create a list of the Day Time entries as string/text value, not date values as excel will see those dates as a number. Then implement this like the video example
A drop-down list with 10 names. in line 1 choose name number 1, in line 2 do not show name number 1 because it was selected before. continue like that until the end. can this be done?
should work, give it a try
Aggghh...though I think I've entered the correct formula (it would be easier if you could put the formulas in the description), it's not working. The first 3 columns look like yours, but when I type a name in the first sheet, the the cell shows formula error not blank - any ideas please?
Check you formula for where it might be breaking with the formula evaluator. ALT + T U F
Hi;
Can this work be done in google forms ?
like a validation drop down in Google sheets? If so...it could..maybe a future video.
@@DougHExcel drop-down list that decreases after dynamic selection.
(Google Form)
List 12345
Select 1 :4 (1235)
Select 2 : 5 (123)
Select 3 : 1 (23)
ahh I haven't explored Google Forms, but if it is like other forms type applications, it should have a branching function where you'd manually select the list of outputs if someone made a selection. It could be tedious to set this all out.
traduction en excel 2016 français, les formules: attention: pour l'exemple de la video poser
a2:a6 et b2:b6 à cause de l'entête.
=SI(NB.SI(listederoulante;A1)>=1;"";LIGNE())
=SI(NB.SI(listederoulante;A2)>=1;"";LIGNE())
=SI(NB.SI(listederoulante;A3)>=1;"";LIGNE())....
=SI(LIGNE(A1)-LIGNE(A1)+1>NB(B1:B6);"";INDEX(A1:A6;PETITE.VALEUR(B1:B6;1+LIGNE(A1)-LIGNE(A1))))
=SI(LIGNE(A2)-LIGNE(A1)+1>NB(B1:B6);"";INDEX(A1:A6;PETITE.VALEUR(B1:B6;1+LIGNE(A2)-LIGNE(A1))))
=SI(LIGNE(A3)-LIGNE(A1)+1>NB(B1:B6);"";INDEX(A1:A6;PETITE.VALEUR(B1:B6;1+LIGNE(A3)-LIGNE(A1))))...
Sorry, don’t understand the comment/ question...
@@DougHExcel thank you very much, my comment for those who use french excel
Hi الأدب الرفيع, thanks for adding to the thread!
The video socks, it doesn't tell you how to make these complex formulas to actually make it all happen.