Excellent video! I have an issue with the 'Text Box'. I made the search bar but after I click on the 'Design Mode' to deactivate it and enter text in the activeX text box, the cursor does not show. I type and no text appears in the Text Box. I can see the text typed into this box show on the 'LinkedCell' but not within the actual Text Box. I'll be grateful for any help.
thank you so much, its help me alot superb tutorial and its easy to follow your steps. by the way you can add in your video on how to put developer tab most of us doesn’t show that tab.💯👏♥️
great tool indeed, just qns, for any blank columns in source data table, the value is coming as 0 in result column, how to suppress the 0 value? Appreciate your help here
Hi bro, no filter function on excell 2019 version. So plz share alternate function using search bar options, plz make a video or share ur idea on how to make other functions using .... Thank U
This might be because ActiveX control is disabled. Check it on File/Options/Trust Center/Trust Center Setting/ Enable it if disabled and see if it works.
Filter function is available in latest Excel versions, hence, this method can't be used in old Excel. I will upload a tutorial if I found any alternative method that applies to old versions too.
Spill error happens due to blockage in the range where the result is trying to populate. Make sure all cells are blank (right and down) from the first formula cell.
thanks for sharing such great knowledge, please keep sharing, thanks again,
Welcome 🙏
Thank you so much dude, hope you live a long life ❤❤❤
Thank you too
Hands down, phenomenal! I never subscribe to anything, but you sir, have my support!
Thank you
Excited by your teach, thank you very much
Welcome 🙏
Love your easy explanation. Could you please provide us some video for creating search box with navigating through many sheets as well? Tnx👌👌👌
Noted. Thanks for the suggestion
gr8 sir... that's very easy and 100% working... keep it up
Thanks and welcome
worked for me, i have a question, what if I don’t want the table to appear unless I search for something
You are super super awesome my brother..... thank you so much for sharing your knowledge and excel files Bless you
I appreciate that!
Worked for me. Thank you so much
Welcome 🙏
thks bro.
Welcome
Excellent video!
I have an issue with the 'Text Box'. I made the search bar but after I click on the 'Design Mode' to deactivate it and enter text in the activeX text box, the cursor does not show. I type and no text appears in the Text Box. I can see the text typed into this box show on the 'LinkedCell' but not within the actual Text Box.
I'll be grateful for any help.
please check the fore color property of text box, it may be set as white. Try changing the color and see if it works.
Please sir, is there any way where you can search for date without converting it to number format?
Hi, it is really useful. If I got a bigger table, is there a way to exclude one or more specific columns from the result of the search? Thanks
To Exclude column, while writing the formula, do not take the columns that you want to exclude.
thank you so much, its help me alot superb tutorial and its easy to follow your steps. by the way you can add in your video on how to put developer tab most of us doesn’t show that tab.💯👏♥️
Thanks for the tip!
Thank you so so much, highly recommended.
Glad you enjoyed it!
great tool indeed, just qns, for any blank columns in source data table, the value is coming as 0 in result column, how to suppress the 0 value? Appreciate your help here
Hi bro, no filter function on excell 2019 version. So plz share alternate function using search bar options, plz make a video or share ur idea on how to make other functions using .... Thank U
The same problème with me
Thank you so much ❤Sir
Welcome
Nice video keep it up. How to remove copy past option in search bar only typing opination should be there. pls help me with this. thanks
Please make the video for without filter function
It worked, but why the data source from the table doesn't show all the search data in the search box?
It should show all data, could you share your working sheet in spreadsheetforu@gmail.com ?
Will check and revert.
great video sir but i have a small dout is this dynamic
Dynamic in a sense, it is able to search and display values automatically
Thank you sir
Welcome
I don’t have filter function why ? and how to do without the function or is it possible to get that function
Hi Mr PK , I cannot seem to enter text into the text box after I come out of the design mode, I am using Excel for office 365
This might be because ActiveX control is disabled.
Check it on File/Options/Trust Center/Trust Center Setting/
Enable it if disabled and see if it works.
Thank you so much sir!!
Most welcome!
What IS your excel version ?
I have excel 365 but i cannt find the fonction filter ?!
Filter function should be in Excel 365, is your software updated?
The link is not working, please update. Thank you.
The link should be working fine. What error did you get?
sir, i used ms office 2016 and there are no filter formula available only available filterxml, please tell me how i supposed to do this ??
Filter function is available in latest Excel versions, hence, this method can't be used in old Excel. I will upload a tutorial if I found any alternative method that applies to old versions too.
@@spreadsheet_power E' possibile introdurla in una versione di excel meno recente tramite UDF?
How do you write the star symbol 😭 please answer
Normally, it is in the number 8 key in keyboard. Need to type it with SHIFT key.
Dear this not work in excel on mac
Could you please tell us how to do it on mac
In which part this didn't work? Any function not available or the same formula didn't work? Could you explain?
@spreadsheet_power developer part not complete in Ios excel
And how to ths steps? If you have multiple, or double header in your table?
can you create a 2024 excel? filter is not working anymore
Which Excel version are you using?
GOOD One
the formula worked but instead of month some numbers are appearing. how can I resolve that?
This is due to cell formatting, select the column and change cell format to date
Can we connect because it’s not working
Please write a mail to spreadsheetforu@gmail.com along with the attachment of your working file.
We will check and reply
اشكرك ارجو الترجمه الي اللغه العربيه يمكن استخدام الترجمة الصوتيه العربيه
Thank you for the suggestion
What is your version of Excel?
It is Microsoft 365
Hi.. im from philippines.. what to do, in my Excel i Don't have "FILTER" Function , pls...help
Unfortunately, filter function is not available in old Excel versions, to use this, you should have lateat version.
Thanks for your support
Thank you too
❤
❤️
Filter function is not available in excel
For this, you need to have latest Excel version
This formula is not working in Excel verson 2019
Yes, for this latest Excel version is required
WAW
My Excel has no FILTER formulas
To get access to filter function, you have to purchase latest Microsoft Excel version, or use the web version of Excel.
This demonstrates how to use the FILTER function, not how to search!
Faltu decribing
I'm facing problem,,once done it's showing #SPILL! In the cell
Spill error happens due to blockage in the range where the result is trying to populate. Make sure all cells are blank (right and down) from the first formula cell.