Magic Search Bar V3.0: Reloaded with Multiple worksheet and Specific column Search
HTML-код
- Опубликовано: 16 сен 2023
- #MagicSearchBar #ExcelTemplates #SearchBoxinExcel
Hello Friends,
This is the third version of Magic Search Bar in Excel. This is a step-by-step complete tutorial and we have added below new features in it:
1-Input Text Message
2-Multiple Worksheet Search
3-Specific Column Search
Subscribe our new RUclips Channel:
/ @neotechnavigators
Download the practice file below link:
www.pk-anexcelexpert.com/magi...
Learn the more than 100 Excel formulas
www.pk-anexcelexpert.com/form...
Use of Symbols and Emojis in Excel Drop-down List and Excel Charts
• Use of Symbols and Emo...
Learn Step by Step Pivot table:
www.pk-anexcelexpert.com/pivo...
Download the Free Project Management Dashboard
www.pk-anexcelexpert.com/exce...
See our Power BI Dashboard videos:
• Power BI Tutorial
Learn and download our interactive Excel dashboards free of cost-
• Excel Dashboards
Download the Calendar Control in VBA from below link
www.pk-anexcelexpert.com/full...
Watch the Step by Step tutorial for Project Plan (Gantt Chart) in Excel
• Project Plan(Gantt Cha...
Download our free Excel utility Tool and improve your productivity:
www.pk-anexcelexpert.com/pks-...
See our Excel Products:
www.pk-anexcelexpert.com/prod...
Visit to learn more:
Chart and Visualizations: www.pk-anexcelexpert.com/cate...
VBA Course: www.pk-anexcelexpert.com/vba/
Download useful Templates: www.pk-anexcelexpert.com/cate...
Dashboards: www.pk-anexcelexpert.com/exce...
Watch the best info-graphics and dynamic charts from below link:
• Dynamic Graphs
Learn and free download best excel Dashboard template:
• Excel Dashboards
Learn Step by Step VBA:
• VBA Tutorial
Website:
WWW.PK-AnExcelExpert.com
Facebook:
/ pkanexcelexpert
Telegram:
t.me/joinchat/AAAAAE2OnviiEk5...
Pinterest:
/ pkanexcelexpert
LinkedIn:
/ pk-anexcelexpert
Twitter:
/ priyendra_kumar
Instagram:
/ pkanexcelexpert
Visit our Amazon Store
www.amazon.in/shop/pkanexcele...
The spilled ranges, the 365 formula and on top of that using namerange like variables in coding are just SO SMOOTH and satisfying to watch.
The cleanest excel search bar video you got on youtube.
I absolutely agree with you
Very clever, PK. A useful tool that also demonstrates many non-VBA advanced Excel features. You use the Name Manager far more aggressively than I; this illustration prompts me to be more aggressive. Thank you! BTW, I love the kids yelling in the background. It sounds lively there!
Glad it was helpful!
Excellent use of the new Excel spill functions.
Glad it was helpful!
This is incredible! Thank you for sharing your knowledge and experience with the new Excel spill formulas!
My pleasure!
This is just genius. So so helpful and cant wait to try this. You have no idea how helpful this will be at work. Magnificent piece of work and grateful you shared.
Thanks for your valuable feedback🙏
How do I contact you. I had sent some quarries on your mail but no reply.
Great knowledge share, my friend! I learned a lot from working my way through your video!
Thanks for your valuable feedback 🙏
Thank you so much sir. you are great people
My pleasure
Holy moly, the Name Manager inside Formula is where ALL THE MAGIC HAPPENS ahahaha
That's right
Simply Amazing!!! thanks so much PK :)
amazing
Thanks
Fantastic!
Many thanks!
I really really love it...great job...thank you for sharing...❤❤❤
Most welcome🙏
This video is super useful!
Glad you think so!
This is impressive, thanks for sharing your knowledge ❤
Most welcome🙏
Thank you so much, Sir.
Most welcome🙏
Excellent tutorial
Thanks🙏
Thanks sir to provide the search function into multiple worksheet as you said.
Most welcome🙏
Sir any solution
Please provide this functionality in VBA so that we can access the same in our work.
that's so smart way 👏
Thanks
soo cool - THANK YOU
Most welcome🙏
have to be the best thing I have seen on YT today. Great Job brother.
Wow, thanks!
Superb sir ❤
Thanks🙏
Great
it is great
Thanks🙏
Great video. Is it possible to also search any comments associated with a cell(s)?
You are amazing!]
Thanks 🙏
Hope you could create the same protect on google sheets. … I’ll be way👍
Will create soon
thanks a lot, can u arrive to the same result with previous version of excel. where there is no function as filter or vstack....?
This is another fantastic feature from you. very well explained. Already replicated the earlier version (2.0) in my work. Thank you!
One issue I have encountered is the moment I drag my excel to extended screen, the activex text box becomes unresponsive. I know it is excel bug. if I drag it back to laptop screen or main screen, it works fine
Good to know, thanks.
Can we crease multiple search boxes -- Like -- Coutry, City , Office, Title etc ...
I want to learn one feature to add in this search box, example - if i want three month data, if i "search Jan, march, jun" this feature is added in this version?
I can edit the data after searching?
Thanks for making video.
Sir, Finally Done sir, In search bar display the Name
Thanku sir…
Sir Great think sir, Your Ideas are excellent sir
Really I thanks for your preparation time is too hard
Really Excellent sir
We are lucky to watch your beautiful videos sir
Its true sir
Congrats for your Hard work
We are every videos enjoying sir
Once again Thanks for I have informed need in Search box Type Here any Text
But you have done any VBA code sir
Excellent sir🙏🙏🙏🙏💐💐💐💐
Thanks for your valuable feedback🙏🙏🙏
Sir is it possible to do like
Excel each header column name upper side search box to search the entire column
And each search box display the name as you done this video like “Enter Here”
Like that sir
Filter function not working can you help me with this problem, I really need this search fucntion thank you in advance
How do I keep the website links in the cell? The search box feature removes the hyperlinks.
Any suggestions to make this run faster? it is slow when I click on the ActiveX box to type a keyword. Am I searching too much data?
Nice video. Would have been easier to follow if you hadn't changed some of formulas and named ranges in the download video
Thank you for this amazing presentation. However, when i have created the search box and i go to search something in the field, there is no visibility of the flashing cursor. Also when i type, it displays on cell A1 but does not display in search box until i click off the search box into another cell. How do i get around this?
I'm using Excel 2019 and Filter function is not available, do you have an alternate code for FILTER?
We can create button hidden text in custom column or row? Plz
Putting value in text box shows it into the linked cell but data not filtered in the new place. Please help solve this problem
thank you for an amazing video.
i have some questions.
how can you sort your result from A to Z.?
for example. in names. can you sort it out from A to Z?
It is bit confusing because there are two many name managers so u tend to forget which is which. However it is a great video. 👍
Dear sir.
How to create A search box two different data with two different headers in one search box.
If you do this challenge?
great tutorial.
Sir may i ask how can i get from add-ins the filter function,sort function and xlook-up function?
I'm very annoyed about these formulas i cannot find it😥
please someone tell me how can i get it😭
Sir, iska v4 kab laoge jo office 2019 me bhi chal jaye ya iske liye koi vba code wala hi bana do please.
what if include hyperlink on the items that need to filter also
hi pk . Could you give a similar presentation with numbers instead of text
will try to create
sir please make ISP management project
Hello PK, how can i not display zero's from emplty cells
Please share this excel if multiple sheet with different headers
Thank you sir. can we give column number instead of typing column name before ":" ?
Yes we can. We have to change the formula accordingly
Can we search the date from this utility..if yes then please let us know
Yes we can. Try to add in next version
It's really great, but it's too difficult to remember,
Sir, Always I am watching your videos, I live in Dubai but am Bangladeshi
and I never miss any videos (I really love your videos so much),
Sir, please can you advise me on how can I memorise these formulas?
Good question, it just takes practice. It's important to understand how the formula works rather than remembering the technique.
Sir if we use numbers(like ids, employees id code)for search how we do that.
Yes you can
Sir, Good Video. But, how to use this SYNTAX STRUCTURE in PREVIOUS VERSIONS OF EXCEL??
Afaik, it's not possible. It uses the new Filter Function. You would have to find an alternative method.
Dear Bro, I have tried this on Microsoft Office in Windows, and it works fine, but when I try to use it on a Mac, the search bar doesn't work.
I have a question. Is there a possibility to search with multiple filters?
For example you search month:jan ; supervisor:pk
Is this possible? Please let me know
Huge video thanks !!🙏
Yes It is possible. we have to make the change in the formula. will try to create a video on it.
How can you memorize all this!
My mind is not ready.
There is one better improvement you should consider:
instead of writing i.e "name:" in the search-box, you should put all table headers in dropdown list then add":" then search criteria. in that way, it'll be easier and more efficient. I hope you got my point
I absolutely agree with you, sir. With the drop down could be much more intuitive.
at 16:38, it doesn't have all names containing 'Jan', please suggest the reason for this. thanks
Because filter function has not yet been applied till that step..
Why my excel don't have vstack function?
VSTACK function is only available for *Microsoft 365* (both the desktop app and the web version)
That's right
I am using Excel 2021, is there any other function/formula I can use in place of VSTACK?
@@oluwandetowoju6323 in r/excel reddit, someone posted "poor man's alternative to vstack", the solution provided there was to use LET function, inside it got two SEQUENCE functions to each handle the rows and columns for multiple datasets/ranges)
@@oluwandetowoju6323 try =TEXTJOIN to stacking rows
what If I want to search by month and name ?
We have changed the formula accordingly
@@PKAnExcelExpert I did same as ur video, but I can only search by specific column
=FILTER(DATA,NOT(ISERROR(SEARCH(SEARCH_TEXT,COMBINED_COLUMNS)))) this code is not working showing error
It seems like there might be a syntax issue in your formula. It appears that you have nested SEARCH functions within each other without closing parentheses. Here's a corrected version of the formula:=FILTER(DATA, NOT(ISERROR(SEARCH(SEARCH_TEXT, COMBINED_COLUMNS))))Make sure you have the correct number of opening and closing parentheses, and this formula should work as intended to filter your data based on the SEARCH_TEXT within the COMBINED_COLUMNS.
His code actually has the correct amount of closing parentheses and you provided the same code with just additional spaces.
The problem is in their COMBINED_COLUMNS formula. Double check and make sure that it correctly gets the right cell range.
It is not works in excel 2019
only 365
Big Thanks for the video. if you have time can you do 4th edition as well please.
Just FYI (vticks) formula not working in my office is it office 365 ?!
1- Term of use option can you addd
2- Protection for sheet coz sometimes they can mistakly change
3- How to Connecting dashboard or written VBA if you have
thanks in advance I know i asked a lot i mean if you have time if not it is okay
Again many many thanks