Grab the file I used in the video from here 👉 pages.xelplus.com/multiple-searchable-dropdown
@deepakmirchandani1348
Жыл бұрын
thanks a lot ma'm for the solution , of this problem i was looking for a long time. great
@arumihehe
3 жыл бұрын
Hi, Leila. Thanks a lot for this video. If I may ask, can you make a video about 3 Dependent Dropdown List that I can apply to multiple rows.
@yaxmokwa7612
4 жыл бұрын
Liking in advance. Will watch later in the evening. Thank you Leila, always.
@mikemorrione8899
3 жыл бұрын
This is a good technique if the filtered list remains the same size, but as soon as the number of drop downs required increases, you need to add more entries into the filtered list. I do not see a simple way to do this automatically. Any ideas?
@julianajusthova6258
4 жыл бұрын
Hello Leila, thank you a lot for all videos you are doing! I would like to also know if is possible to make searchable dependent dropdown list. Thank you a lot for help :)
@shimed2005
4 жыл бұрын
first of all I thank you for your gracious work it is really helpful and I just want to ask you about some of these functions which are not available in my copy of office 19 so I was wondering how to get this in office 19 since I don't have Office 365
@LeilaGharani
4 жыл бұрын
You can't. The new functions will not come to Excel 2019.
@shimed2005
4 жыл бұрын
@@LeilaGharani thanks for your concern
@joehegedus3229
4 жыл бұрын
Wow, been looking for this (and trying to do it on my own - got close). I followed your instructions and it works great. Is there a way to when you start typing that the dropdown list appears (maybe after 2 letters?) and as you continue to type the list gets less and less? Thanks much for sharing this video and let me know about my question. Meanwhile I will try something on my own. Thanks again.
@deniscore000
2 жыл бұрын
Always great content, thanks, but I am missing basic Excel features as how do you expand the search results to the entire D1 column when closing bracket/pressing enter at around 2:43 minutes of the video? Mine is not working like that. Thanks
@souzamotasacul
2 жыл бұрын
That’s a spill formula, it goes automatically
@1991lauratjeuh
3 жыл бұрын
Thank you !!
@joehegedus3229
4 жыл бұрын
Question/suggestion... Is there a way to, when you start typing, that the dropdown list appears (maybe after 2 letters?) and as you continue to type the list gets less and less entries (only one matching typed letters)?
@mehranmehri
4 жыл бұрын
You need some VBA code to handle this! Without VBA I have no idea!
@ekawibisana2828
3 жыл бұрын
You might want to try this if you have fewer data. Let's say less than a hundred first please watch this trick: kzitem.info/news/bejne/sYx74HyYnXqXZI4 second, create your list and then hide them you will see the sugestion / autocomplete based on what you are typing
@liquidbydesign
3 жыл бұрын
Thanks for your video! I found a way to use multiple searchable drop-down lists with only one data validation prep list, that should reduce the file size if you have many drop-down lists. If you input the formula =CELL("contents") into a cell, that cell is updated with the most recently updated cell value in the worksheet. All I did was following the guide, using the formula =IF(CELL("content")=0,"",CELL("content")) in cell D1 and instead of Report!B5 in cell D2 I used D1. With that IF-function included, the formula returns "" instead of 0 if the last updated cell is empty. An important change to be able to browse the complete list with no text entered.
@karinaaguilar2279
2 жыл бұрын
I tried this option and works almost perfectly, but when I go to the next cell to fill, it filters and only displays the values that meet the past criteria. You said that with the IF function it would be solved, but that doesn't seem to be the case for me. Do you have any advice?
@golfnutt1969
2 жыл бұрын
If you came to this video after watching the original video (Searchable Drop Down List in Excel (Very Easy with FILTER Function), you can skip to 5:36 in this one, as up to that point, it's just an intro and recap of the previous video.
@TandangSugistiawan
4 жыл бұрын
Thank You So Much.. this is very helpfull
@carlosborba3453
4 жыл бұрын
Thank you!! That transpose step will help me so much! A question: if a type a name but not use Capital Letter like in table Customer[Customer], result is "not found". Is supposed to happen this? Thank you again and #stayhome
@AndreShiotani
4 жыл бұрын
I have the same problem here.
@axox1990
4 жыл бұрын
very intelligent way thanks
@Brushoi
4 жыл бұрын
Thanks a lot!!! Exactly what I was looking for! By the way, Leila, how would you be able to create multiple dependent dropdown lists for many rows like that?
@arkietech5823
4 жыл бұрын
Very good explanation. I was looking for something like this. Thank you for many helpful videos. Can you do a video using multiple (about 20/worksheet) searchable drop down lists on 20-30 worksheets and all worksheets using the same master list from sheet 1 in same workbook?
@stephanegeorgiev6082
Жыл бұрын
it works and it's great But there is a problem, I have much longer list than yours and my excel file become very very slow, suppose it's because of lots of calculation steps. Did you find another way to multiply the SEARCHABLE Drop-Down list or this is the latest idea you had ? thank you
@robinhuijbregts6011
3 жыл бұрын
Dear Leila, would there be a way to make a searchable dependable drop-down list. I've got 20 column's and 2000 rows of nutrition data. I've been experimenting but can't seem to figure it out, maybe other people also have this problem
@LastCall6am
3 жыл бұрын
I used a trick I saw in another video to link the helper table to the current cell being used. By using CELL(“address”) inside the indirect function to replace the “find text” cell reference in the formula. It’s still has a bug though; you have to click into the cell to reset the helper table. Hope this helps. =FILTER(Table[data],ISNUMBER(SEARCH(INDIRECT(CELL("address")),Table[data])),"Not Found")
@analopes9295
Жыл бұрын
Hi, can you please advise how you used this? I cannot use transpose because my results are over the columns limit.... Thanks 🙂
@rfarhad69
3 жыл бұрын
Thank you for your video. I have a problem that is i'm using Office 2010, how can i get Sort & Filter Function in office 2010. Is there any alternative function for Sort & Filter. I will glad if replay me. Thank you.
@jasontan4730
4 жыл бұрын
My data entry form is an Excel table, hence to cater for dynamic data range. I'd suggest to use the INDIRECT(CELL("address")) feature within the SEARCH formula. This eliminate the needs to Transpose data and no need guess total rows needed.
@analopes9295
Жыл бұрын
Hi, can you please advise how you used this? I cannot use transpose because my results are over the columns limit.... Thanks 🙂
@excelisfun
4 жыл бұрын
Is there nothing FILTER can't do?
@LeilaGharani
4 жыл бұрын
Agree - FILTER is the Best!
@diguzel1125
3 жыл бұрын
@@LeilaGharani I can not find Filter function
@garys2187
4 жыл бұрын
I really like the way that you explain each step and working the formula from the inside out. It helps me to understand what is really going on.
@mattschoular8844
4 жыл бұрын
Thanks Leila. I have been using your first solution successfully for a couple weeks. This transpise solution gives me more options. In my solution I added a column in my master data table where I used Concat to join 3 separate columns. I then used this new helper column to allow me to search text on first name, last name or company name. My XLOOKIUP could then return company ID. It works well. Thanks for sharing your solutions. Keep up the great work.
@LeilaGharani
4 жыл бұрын
Fantastic! It's great you could implement it successfully.
@shakisshenanigans6305
4 жыл бұрын
I tried this but as I type, my validation list does not update. I have to enter value in the cell first and enter before my dropdown list will show correctly. What am I doing wrong? Also, when I try to adjust the validation to be able to copy down to the other cells, when I remove the $ it tells me there is an error and won't allow me to save that validation.
@jetnjoro9471
4 жыл бұрын
I have encountered a similar issue. Any solution. Otherwise great videos making the complex in Excel simple - with no VBA! :-)
@CKitchen-ti9bd
4 жыл бұрын
Hi Leila, thank you for the great video. A few questions, I tried to use it, but when I type in the target cell for the main formula to work, it didn't update realtime like in this video. which means I have to enter first (automatically exit the cell), before the content from the dropdown list is updated (so I have to reselect the dropdown list after pressing enter). Any idea why and how to fix this? second question, can I use this with a large number of rows? will it be efficient? Thank you
@brandybrandy2210
4 жыл бұрын
I am having the same problem
@jorgeo6342
4 жыл бұрын
Same here, please help on this
@henryg5735
4 жыл бұрын
Very cool. But what if the originating data entry cell where the dropdown is needed is contained in a table? And it is not possible, in advance, to know how many rows may eventually be included! This is a fairly typical data entry scenario. I haven't (yet!) been able to come up with a solution.
@debjitpaul3399
4 жыл бұрын
This is a brilliant video tutorial for beginners like me. Thanks! But as i searched more, i noted that a much simpler way to achieve this from your last video would be to use the concept of "active cell" (CELL("content") formula) in your search formula and write one line of code in vba (application.calculate). I know this says "no vba" tutorial but since its that small a piece of code, you can mention that in such videos so users can choose wisely.
@golfnutt1969
2 жыл бұрын
Most people avoid VBA, not because of the amount of code, but because it requires your workbook to be macro-enabled. These aren't always safe to share as they can contain malicious code, so many companies will block these. So, just because it is only one line of code, that is too much.
@wayneedmondson1065
4 жыл бұрын
Hi Leila.. cool solution. Thanks for sharing it. I was intrigued to see if I could duplicate it without dynamic array functions. Came up with this: On your MasterData sheet in cell D2: =IFERROR(INDEX(TableCustomer[Customer],AGGREGATE(15,6,(1/ISNUMBER(SEARCH(Report!$B5,TableCustomer[Customer])))*(ROW(TableCustomer[Customer])-ROW($A$2)+1),COLUMNS($D2:D2)))," "). Copy this down to row 32 and right to column AH. With the cell pointer in cell B5 on the Report worksheet, create a named range (I called mine myDropData) with the following formula: =MasterData!$D2:INDEX(MasterData!$D2:$AH2,COUNTIF(MasterData!$D2:$AH2,""&" ")). Then define Data Validation for B5:B19 on the Report worksheet as: List and =myDropData and turn off the error alert for invalid data. Also, for C5 enter: IFERROR(INDEX(TableCustomer[Company],MATCH(Report!B5,TableCustomer[Customer],0)),"") and copy down to C19 to match the selected name with the company or a blank if no match. The above pretty much works like yours, except that the drop list data is not sorted.. although you can sort it at the data table level to achieve the same. If there is no match to what you type in the data validation cells in B5:B19, you get a drop down with nothing in it (all the " " blank spaces from IFERROR). Otherwise, it has the same functionality.. although more difficult to set up without dynamic array functions. Anyway, I love your technique and it was a great inspiration to create something for those without DAFs. Thanks for all the good learning at your channel and thumbs up!!
@vncmra
4 жыл бұрын
The best, thank you
@eduardonozawa1935
3 жыл бұрын
I was very excited about the solution, however I have a list with ~10000 rows and a data validation list with about 50 entries, so that the solution would be prohibitive. The dynamic name would be great, but...
@eduardonozawa1935
3 жыл бұрын
Define name like this =OFFSET($F$2,0,0,COUNTIF($F:$F,"?*")) .Consider that F2 is the Filter array first cell. It works !!
@gdjenkins10
3 жыл бұрын
Thank you for the great info!! I have implemented a variation of this for 300 rows of lookup on Sheet2 where Sheet1 uses the data validation. My actual lookup table is 1500 rows. I am getting a number of reports back from my users that using Column Filtering on Sheets3-5 have slowed down to a minute or so after adding the transpose=>Sorter=>Filter to support 300 rows. Do you have any suggestions to help bring performance back to the other worksheets in the workbook that are not using this capability?
@ismailismaili0071
4 жыл бұрын
Thank you that was epic
@gdjenkins10
3 жыл бұрын
With further testing, the 300 rows of Filter(Search) formula takes the file from 1.9MB to 11.5MB. Each row defaults to 1500 cells until search is done. I ended writing a macro to add the 300 rows of Filter(Search) and remove them after the tab is filled in. The remaining tabs use Table Column Filtering to search. WIth the 300 rows of Filter(Search) is in place, each use of table column filter takes 1 minute or more to filter the 1500 rows of data. When I remove the 300 rows of Filter(Search), the same selection using Table column filter takes 1-2 seconds. Is there a way to leave the Filter(Search) in place but stop their influence on table filtering?
@janbongers3133
3 жыл бұрын
I find your solution to a searchable list perfect. With my excel 365 the dropdown list is very small font and when I download your file I can read the dropdown list well. Maybe you have a solution for this. thanks in advance Jan
@mounirbelazi8071
3 жыл бұрын
Dear Leila, first of all I would like to thank you for the great work. Your videos are fantastic. The current solution works very well but I'm wondering what I can do to keep the file size reasonable when I would like to use this solution for 1k to 5k rows? Many thanks Mounir
@xnoztm
2 жыл бұрын
Have the same question. waiting for someone to response this. Maybe we’ll find other method
@YouRQ7XL
2 жыл бұрын
yeah 1k row give me 100MB xlsx so no usable unfortunately :(
@martinjudd952
Жыл бұрын
@@YouRQ7XL See the answer above where they used an =IF($B5="","", Transpose(Sort(Filter(Search....... ) Seems like a quick solution.
@CosmicRaysHealing
2 жыл бұрын
How to make this list if you have same exact names in different divisions ? (e.g., there's a Rob Wilson in Utility and another Rob Wilson in Productivity..)
@961mjazouli1
4 жыл бұрын
Hello Leila.What if we don't have office 365 and the filter feature??
@ituryu
4 жыл бұрын
Thank you for this insightful and useful video, it was a solution that I have been searching for, but the only issue I am encountering now is the inability to have this replicated as a copy and paste in multiple sheets in the same workbook !!!
@AusFastLife
Жыл бұрын
Amazing solution. Your are a genius. Can I ask, is there a way of getting those transposed prepared lists as shown at 8:39 to spill down automatically depending on your table size. I see you selected how many rows you had (something like 15 entries in your case). My table that I need the searchable dropdown list for needs to run for a whole financial year, so there will be an unknown number of rows numbering in the hundreds. Ideally I would like the preparation lists to create themselves as new rows are added to the table, rather than someone having to manually copy down the preparation list as new data rows are added.
@angelgilm
4 жыл бұрын
Great, Leila! Did you try using INDIRECT to get range names working properly in data validation formula?
@bodyb0arder
2 жыл бұрын
I tried it but does not work, I bet there should be a way
@mattkennedy8603
3 жыл бұрын
Thanks this is great! Any way to apply this to an Excel Table with an undefined # of rows? I am struggle to understand how to scale the solution as the table grows. Seems like we have to drag the formula down when a new row is added.
@jameswilliams8409
4 жыл бұрын
simple question, I have this all set up and it works just fine except when I type a few letters for my list selection it doesn't auto update the list unless I hit enter and I don't see you having to do that in your videos. So if I type "to" and then click on the drop down list icon I will only get my filtered list if I hit enter or select a different cell and then click the icon.
@domenicogalletta
4 жыл бұрын
Molto interessante!
@meckhel
Жыл бұрын
This is what I have been looking for, however when I added TRANSPOSE() and press enter, i received an error #SPILL!------>TRANSPOSE(SORT(FILTER(TableStock[TICKER NAME],ISNUMBER(SEARCH(D2,TableStock[TICKER NAME])),"not found"))) Anything that I do wrong? Please advice.
@kandathumkettathumm
4 жыл бұрын
Hai Leila, I saw another method to create a simple searchable drop down list. Just create a pivot table with values in the filter section only. This will act as a searchable drop down list with zero duplicates. This cell can also be referred for formulas.
@raymondmoy1973
Жыл бұрын
Hi, can you show me a video about this? Interested
@MrCoolphoenix
7 ай бұрын
Thanks a lot Leila! That is a very informative video as usual. I have learnt a lot from your Udemy courses. Is there any method to make dynamic searchable lists from source in multiple sheets using INDIRECT in Data Validation? I tried using INDIRECT with # inside brackets, but it doesn't work.
@bhagirathq
Жыл бұрын
Hi Leila, I am a user of a subscribed version of Office 365. I've inserted the multiple rows validation in a table which should expand to its added rows and it does too. However, the transposed spill is jumped to next row number when I add a new row to my table (it works fine with searchable functionality when I work with already built table rows). For example, searchable dropdown works with E10 up to E50 (my dropdown is in column E) well. But if I add a new row to my table - let's say E11, it shows all the transposed list instead of showing searchable dropdown. What I mean to say here is that my transposed list which is dragged to be applicable from E10 to E50 (in a separate sheet) jumps from E10 to E12 without having E11 in between. Can you guide on sorting this out?
@mrhsvf
4 жыл бұрын
is the "filter function" just for office 365? I am trying this on office 2019 and the filter function doesn't work,
@LeilaGharani
4 жыл бұрын
Yes, unfortunately only in 365.
@eaglesmainfan211
4 жыл бұрын
@@LeilaGharani Do you know of any other function that could be used to get the same result?
@you_are_kidding_me_right
Жыл бұрын
When I do "TRANSPOSE" it returns "#SPILL!" as a default rather than the range. EDIT: I found is that the range extends beyond the worksheet limits, that's why is was getting that. Also, you can just do a str8 data validation for multiple dropdown boxes. That was enough for me. Why create another range of the same data?
@mrbewkuf9769
Жыл бұрын
Hello Leila! is it possible to auto expand the list just after selecting the cell without VBA? I think you can make the thing possible because KUTOOL FOR EXCEL can automatically makes any list searchable, and in a very professional and automated manner. We don't even need to click on down arrow and the best part is it work on any xlsx file without macro. The only problem is it works only for them who use this extension. And so sharing the file makes it just basic one.
@lfgraphics
3 жыл бұрын
that's amazing mam but what for us (who don't have access to office 365) please share if there is any solution for us
@ryanpeterson7998
3 жыл бұрын
WONDERFUL!!!!!!!!!!!!! is it possible to do everything in this video but tweak it???? I need it to only pick a name on the list, currently the user can type in any name in the cell and it will accept it. i am looking for a way to still sort (as seen in the video) but make it pick from the list with zero exceptions. tried turning on the data validation error back on but then the sort doesn't work. PLEASE HELP
@iscbala
4 жыл бұрын
Thank you Leila for your immediate response. Actually I am having the monthly subscription pack for Office 365 Personal version. Kindly clarify
@ravenhish
3 жыл бұрын
always Love your video...thx Leia...I Learn more about excel from you everyday...and I found another solution to these by using CELL function...well it has a weakness, but it better than copying the formula for each row...you should look into it...
@mr.write1433
9 ай бұрын
the problem is if you didnt type the second letter and search find the same letter let say "A "and it find in other data "Spain" it will return a value 3. 3 is a number then it will be true
@omaralalawi6469
3 жыл бұрын
Dear Leila, please reply to my question...when I want to copy company name unable to do that nothing copied, how can solve this problem??? Because after filtering I want to copy the result to another place...plz for your kind support💙🌹
@maribeljavier598
8 ай бұрын
Hi Miss Leila, thank you for this technique. I already use and it works. It's just that it's not working if I protect sheet. I uncheck the cells but the arrow is still not clickable. Do you have solution for this? Thank you so much
@archbogs
3 жыл бұрын
Many SEARCHABLE Drop-Down Lists in Excel (No VBA) - This to base and dependent result on a dynamic list? Multiple Dorp Down lIst" Can this be possible?
@012492930
3 жыл бұрын
Hi Leila, This formula is matched with what I am finding to complete my daily excel work. but I am from Cambodia most of the report made in Cambodia Language so the formula can not carch the the words in my country language, it seem it can work only with Engliash. So can you help me go through this matter ? thanks in advance.
@warrenanderson412
4 жыл бұрын
Once Again... You answered my pending question when I saw the first Searchable Drop Down List you posted. You Are The Best!!!
@geerliglecluse5297
2 ай бұрын
This is good stuff. My only disappointment (with Microsoft) is that this solution still requires mouse action after the typing to select the wanted value. That slows down data entry quite a bit, unfortunately.
@ianfairall4509
2 жыл бұрын
I am running into the problem that if you delete one row, it breaks all the data validation formulas after that row. For example, if row 10 gets deleted, row 11 becomes row 10, but the data validation formulas is still referencing row 11 of the "data validation prep" list.
@clubpryda
3 жыл бұрын
AT 9:49, After unfixing the 2, data validation is not accepted. instead I'm getting an error "This formula currently evaluates to an error. Please correct to continue." Please help me sort this issue. Thanks in advance
@ansarimouzzam
2 жыл бұрын
It was really helpful but this serve 50% of my requirement. I get the suggestions when I click on the drop down button. I am looking for the same list of suggestions but that should list automatically without pressing the drop down button.
@haseebahmad8146
4 жыл бұрын
when I click on any cell, or enter a character into the cell, the drop down list will appear automatically. Like as this video............ kzitem.info/news/bejne/u6x5u3qbr6and20 For only One Colum.
@nith10170
3 жыл бұрын
What happens when the list of names (say 20000) is very large wouldn't transpose give spill error? When one doesn't type anything in searchable drop-down. How to handle that?
@ronstraub2964
2 жыл бұрын
Love this training, but my firm only uses Excel 2016. Where can I find your training for this version instead of the 365 version?
@BenjaminEtukudoh
2 жыл бұрын
I really love this video, but I am having the Spill Error when I input the search Formular in the validation column. I don't know How to correct this.
@hlawinkhine82
4 жыл бұрын
Is it possible to create multiple dropdown list in official excel table. To create dropdown list automatically when new row add in that table just lite formula is automatically create. Thank you for your sharing.
@HoaNguyen-zz4cn
2 жыл бұрын
TRANSPOSE function is forgotten in excel. thanks for telling me more about how to use TRANSPOSE
@spreadsheetdoctor
4 жыл бұрын
I have a 65000 row long list. Transpose is not going to work in this case as this will exceed maximum permitted columns in excel. I need to have this file uploaded on a sharepoint so VBA is not an option either.
@TheJettstevens
4 жыл бұрын
Is there any way to have the drop down box to show “Gary Miller” if for example the user typed “Miller Gary”?
@farooqulhassantahir6201
3 жыл бұрын
Dear, Thanks for great solution, but let me know how can we implement in excel 2013, or excel 2010. Thanks
@amarkinskywalker
2 жыл бұрын
Thank you for this Leila! I would also like to ask if how can i use this with multiple columns, i tried addi g xlookup but it didnt work. Hope you notice me and wish you more views 😁
@Be_Ur_Best_Version
4 жыл бұрын
Hello Leila. Thank for this awesome video. Unlike how you are able to automatically update the dropdown options in realtime (when you type and click the data validation arrow), I have to type few letters, then press enter (which goes to next row) and then come back to the cell where partial letters are typed to see the filtered list. What settings do i need to update realtime like yours
@jcrutcher0114
3 жыл бұрын
This works nicely. Like Bethu, the list does not generate once i type in a few letters; i have to leave the cell and return before the cell generates list. Other than that it works exactly like you describe.
@jcrutcher0114
3 жыл бұрын
I should restate prior post. When i enter a few letters, the dynamic prep range is created however, when i click the dropdown I get the full list. If i leave the cell and return the dropdown matches the filtered dynamic list. How can I get the dropdown to sync with the dynamic filtered list w/o leaving the cell?
@bharatsidhwani8904
2 жыл бұрын
Hi Leila, I have been following you since long, I have query and I am sure you will be able to help me out. I want a dependable searchable drop down on multiple cells. Sooner you reply will help me great deal
@eiraqo5685
3 жыл бұрын
I am using excel 2013 and there's no xlookup function. Can you tell me is there any other function that I can use. Thank you.
@gururajpatil4158
Жыл бұрын
It was too good and made my work easy. But, there is a problem, when transpose it occupies al cells next to it till the end of list. If I want to Limit to first 5 search results. How can i do it?
@ronakgarg3650
3 жыл бұрын
Can we implement the similar thing with Older version of excel ? I am facing challenge in referring the dynamic drop down list. Can you please suggest
@gregharrelson8621
Жыл бұрын
I wish this worked for Mac Excel. The validation list won’t update unless you press the enter key, which kind of defeats the purpise
@dannyleblanc336
3 жыл бұрын
Realy great video. qick question: what append if you have 2 same name costomer but different compagny?
@17aig
4 жыл бұрын
What can I say that has not been said already you opened my eyes to so many options, explaining with so much clarity!! and solutions thanks a million
@dzhowto
3 жыл бұрын
Is there a way to do it for bigger data as this method takes a lot of resources
@putri6662
3 жыл бұрын
Why i can't paste validation ? When i paste validation , the data validation is not update for the next cells. Can you help for my problem ?
@ryanemerson7
2 жыл бұрын
Great video. I keep looking for the option that shows the entire list rather than “not found” on the results when you type a name that is not in the drop down. I tried removing or leaving quotations blank- no go. Anyone saw this part on another video?
@andreykasymov5317
2 жыл бұрын
How to make it work properly on a locked workbook? With unlocked cells for dropdowns, the search feature does not work until I click Enter..
@AshokKumar-fu5ze
3 жыл бұрын
What if we add more rows to the customer name? say instead of only 15 we have an ever growing customer name list of rows where this searchable drop needs to be incorporated..
@RajaLakshman
3 жыл бұрын
Is it possible to have two cascading searchable drop-down lists like this which can be copied down - for me the first one is searchable, but the second is not taking the value I enter - it is searching across the entire restricted list.
@chaleolin6423
2 жыл бұрын
What formula should i use besides of "filter" function. I'm using excel 2013
@dagwould
4 жыл бұрын
Can Excel run a variable content drop down list by reference to a cell other than the one selected. So, I want to click on cell b1 and have the list drawn from column c based on the contents of cell a1.
@amjadyahia7357
Жыл бұрын
Brilliant, very good explanation. I was looking for this long time ago, many thanks.🌺🌹
@stimolus
Жыл бұрын
My need would be to have a dropdown on each row to search e.g. IDs which grow by the time goes on, no need to search from few rows, but thousands of rows.
@4UGuys7
Жыл бұрын
It's helpful but when data is a row is 700 above then how to work? Because sheet column is limited
@UU-ry6gt
3 жыл бұрын
Wow! Great job! Is any chance to get it work for depended listS? Or offeset is only one solution?
@suhaibhassan9607
3 жыл бұрын
The filter formula is not present in my MacBook. What is the possible alternate for this formula?
@OostenwaldKotze
Жыл бұрын
Hi Leila I have a list with 1300 users that are split across multiple sites in our country. Will it handle the volume?
@CallipygianMoose
3 жыл бұрын
you just selected the entire column of a table....is that not a feature on office 365 online? because I cant get the little black arrow to show
@naqibabid9635
3 жыл бұрын
Hello, when I password protect the sheet the searching is not working in the dropdown please answer. thank you
Пікірлер: 534