Magic Search Bar V3.0: Reloaded with Multiple worksheet and Specific column Search

No video

Magic Search Bar V3.0: Reloaded with Multiple worksheet and Specific column Search

Рет қаралды 54,477

Күн бұрын

#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 KZfaq Channel:
/ @neotechnavigators
Download the practice file below link:
www.pk-anexcel...
Learn the more than 100 Excel formulas
www.pk-anexcel...
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-anexcel...
Download the Free Project Management Dashboard
www.pk-anexcel...
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-anexcel...
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-anexcel...
See our Excel Products:
www.pk-anexcel...
Visit to learn more:
Chart and Visualizations: www.pk-anexcel...
VBA Course: www.pk-anexcel...
Download useful Templates: www.pk-anexcel...
Dashboards: www.pk-anexcel...
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-AnExcel...
Facebook:
/ pkanexcelexpert
Telegram:
t.me/joinchat/...
Pinterest:
/ pkanexcelexpert
LinkedIn:
/ pk-anexcelexpert
Twitter:
/ priyendra_kumar
Instagram:
/ pkanexcelexpert
Visit our Amazon Store
www.amazon.in/...

Пікірлер: 130

@Chef-1707 11 ай бұрын

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.

@PKAnExcelExpert 11 ай бұрын

Thanks for your valuable feedback🙏

@sandeeppawar7939 9 ай бұрын

How do I contact you. I had sent some quarries on your mail but no reply.

@skenming 5 ай бұрын

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.

@osoriomatucurane9511 4 ай бұрын

I absolutely agree with you

@nunogomes694 Ай бұрын

Thank you so much sir. very god information to priorize time.Thanks for shared

@PKAnExcelExpert Ай бұрын

Most welcome

@jimfitch 6 ай бұрын

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!

@PKAnExcelExpert 6 ай бұрын

Glad it was helpful!

@donbogdala5428 7 ай бұрын

This is incredible! Thank you for sharing your knowledge and experience with the new Excel spill formulas!

@PKAnExcelExpert 7 ай бұрын

My pleasure!

@gorflunk 8 ай бұрын

Excellent use of the new Excel spill functions.

@PKAnExcelExpert 8 ай бұрын

Glad it was helpful!

@HappyMainer 7 ай бұрын

Great knowledge share, my friend! I learned a lot from working my way through your video!

@PKAnExcelExpert 7 ай бұрын

Thanks for your valuable feedback 🙏

@abam9787 11 ай бұрын

Holy moly, the Name Manager inside Formula is where ALL THE MAGIC HAPPENS ahahaha

@PKAnExcelExpert 11 ай бұрын

That's right

@southisacknova 11 ай бұрын

Thank you so much sir. you are great people

@PKAnExcelExpert 11 ай бұрын

My pleasure

@pandharinathjoshi6565 11 ай бұрын

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🙏🙏🙏🙏💐💐💐💐

@PKAnExcelExpert 11 ай бұрын

Thanks for your valuable feedback🙏🙏🙏

@pandharinathjoshi6565 11 ай бұрын

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

@AmitSingh-kb4xr 10 ай бұрын

have to be the best thing I have seen on YT today. Great Job brother.

@PKAnExcelExpert 10 ай бұрын

Wow, thanks!

@hichamhadj9640 11 ай бұрын

This is impressive, thanks for sharing your knowledge ❤

@PKAnExcelExpert 11 ай бұрын

Most welcome🙏

@lorenzocancer 11 ай бұрын

I really really love it...great job...thank you for sharing...❤❤❤

@PKAnExcelExpert 11 ай бұрын

Most welcome🙏

@Harshsanjana 11 ай бұрын

Thanks sir to provide the search function into multiple worksheet as you said.

@PKAnExcelExpert 11 ай бұрын

Most welcome🙏

@Harshsanjana 11 ай бұрын

Sir any solution

@Harshsanjana 8 ай бұрын

Please provide this functionality in VBA so that we can access the same in our work.

@sumantgirase 11 ай бұрын

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

@qasimawan3569 9 ай бұрын

Good to know, thanks.

@petzlica 9 ай бұрын

This video is super useful!

@PKAnExcelExpert 9 ай бұрын

Glad you think so!

@MohAboAbdo 11 ай бұрын

Thank you so much, Sir.

@PKAnExcelExpert 11 ай бұрын

Most welcome🙏

@zaydarendse2812 11 ай бұрын

Simply Amazing!!! thanks so much PK :)

@mohamadsiddeek7912 11 ай бұрын

Excellent tutorial

@PKAnExcelExpert 11 ай бұрын

Thanks🙏

@KrishnaKumar-zn9kg 4 ай бұрын

Fantastic!

@PKAnExcelExpert 4 ай бұрын

Many thanks!

@vijaysahal4556 11 ай бұрын

Superb sir ❤

@PKAnExcelExpert 11 ай бұрын

Thanks🙏

@usman6857 4 ай бұрын

amazing

@PKAnExcelExpert 4 ай бұрын

Thanks

@vacilando86 10 ай бұрын

that's so smart way 👏

@PKAnExcelExpert 10 ай бұрын

Thanks

@zeeshanzeenu 3 ай бұрын

Gazab......Sir

@PKAnExcelExpert 3 ай бұрын

Thanks

@christoph231090 9 ай бұрын

soo cool - THANK YOU

@PKAnExcelExpert 9 ай бұрын

Most welcome🙏

@KidGalahad67 4 ай бұрын

Great video. Is it possible to also search any comments associated with a cell(s)?

@joseelizondo373 7 ай бұрын

Hope you could create the same protect on google sheets. … I’ll be way👍

@PKAnExcelExpert 7 ай бұрын

Will create soon

@andreaspas Ай бұрын

Thanks a lot for the solution!!! I have a question. In the sheets that i search (Not the search box sheet), in a column, i have many hyperlinks, but at the sheet of the search box comes as text, not as hyperlinks. Do you know how can i solve this problem?

@mcegirl4 8 ай бұрын

You are amazing!]

@PKAnExcelExpert 8 ай бұрын

Thanks 🙏

@anupamsarkar5882 17 күн бұрын

Kindly make a video for check box. What if I search multiple products and select check box. Then on another shee, selected check box will show entire row.

@suleymanturkmen2748 11 ай бұрын

it is great

@PKAnExcelExpert 11 ай бұрын

Thanks🙏

@musatenginkeri1823 7 ай бұрын

Great

@Dan_De_Man 7 ай бұрын

Nice video. Would have been easier to follow if you hadn't changed some of formulas and named ranges in the download video

@syedsalman1559 4 ай бұрын

Can we crease multiple search boxes -- Like -- Coutry, City , Office, Title etc ...

@mohammadsafiqulislam5779 11 ай бұрын

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?

@qasimawan3569 9 ай бұрын

Good question, it just takes practice. It's important to understand how the formula works rather than remembering the technique.

@meetdave6952 9 ай бұрын

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.

@nadermounir8228 11 ай бұрын

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. 👍

@khalidmounir3475 11 ай бұрын

thanks a lot, can u arrive to the same result with previous version of excel. where there is no function as filter or vstack....?

@Puerto_Ayacucho_VE 10 күн бұрын

Hello, PK, How can I bring up a row that was selected and highlight, and also the row is not screen visible, meaning is at the bottom of the datasheet to the top in excel,

@bradleonard1865 6 ай бұрын

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?

@markanthonycruzatcruzat6068 3 ай бұрын

Filter function not working can you help me with this problem, I really need this search fucntion thank you in advance

@girishpadshala9689 11 ай бұрын

Thank you sir. can we give column number instead of typing column name before ":" ?

@PKAnExcelExpert 11 ай бұрын

Yes we can. We have to change the formula accordingly

@JeromeTiamson-gj5sj 10 ай бұрын

thank you for an amazing video. i have some questions. how can you sort your result from A to Z.?

@JeromeTiamson-gj5sj 10 ай бұрын

for example. in names. can you sort it out from A to Z?

@aravindpemmadi1052 7 ай бұрын

Dear sir. How to create A search box two different data with two different headers in one search box. If you do this challenge?

@Flo_la 6 ай бұрын

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 !!🙏

@PKAnExcelExpert 6 ай бұрын

Yes It is possible. we have to make the change in the formula. will try to create a video on it.

@Sean9243 10 ай бұрын

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?

@abdullahquhtani8058 9 ай бұрын

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

@osoriomatucurane9511 4 ай бұрын

I absolutely agree with you, sir. With the drop down could be much more intuitive.

@dothework413 6 ай бұрын

How do I keep the website links in the cell? The search box feature removes the hyperlinks.

@saadkamran1729 Ай бұрын

Vstack function not available can't you integrate in to the previous method

@MirMdFaridtuddin 9 ай бұрын

Putting value in text box shows it into the linked cell but data not filtered in the new place. Please help solve this problem

@NGUONVANRADY 11 ай бұрын

We can create button hidden text in custom column or row? Plz

@user-hn3gz2xb1e 10 ай бұрын

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😭

@MT-pe4pm 2 ай бұрын

What if I want nothing showing if the search box is blank? I don't want to show all data when the search box is blank.

@Harshsanjana 7 ай бұрын

Sir, iska v4 kab laoge jo office 2019 me bhi chal jaye ya iske liye koi vba code wala hi bana do please.

@paulmotion733 Ай бұрын

how to make it in excel 2016, the filter function is missing. any solution?

@yahyaramadhan2698 10 ай бұрын

hi pk . Could you give a similar presentation with numbers instead of text

@PKAnExcelExpert 10 ай бұрын

will try to create

@ghiidee 8 ай бұрын

I'm using Excel 2019 and Filter function is not available, do you have an alternate code for FILTER?

@samprime3180 8 ай бұрын

Hello PK, how can i not display zero's from emplty cells

@sharad24agrawal 11 ай бұрын

Please share this excel if multiple sheet with different headers

@marvinaceroque3790 9 ай бұрын

what if include hyperlink on the items that need to filter also

@bsnlftth69 11 ай бұрын

sir please make ISP management project

@EM-GAMER-YT 9 ай бұрын

=FILTER(DATA,NOT(ISERROR(SEARCH(SEARCH_TEXT,COMBINED_COLUMNS)))) this code is not working showing error

@sumantgirase 9 ай бұрын

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.

@aCatSiki 6 ай бұрын

His code actually has the correct amount of closing parentheses and you provided the same code with just additional spaces.

@aCatSiki 6 ай бұрын

The problem is in their COMBINED_COLUMNS formula. Double check and make sure that it correctly gets the right cell range.

@diya2909 11 ай бұрын

Can we search the date from this utility..if yes then please let us know

@PKAnExcelExpert 11 ай бұрын

Yes we can. Try to add in next version

@asifhossain8605 8 ай бұрын

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.

@rajamit136 Ай бұрын

sir 2nd version samjh me aaya lekin 3rd wala nahi samjh me aa raha hai.kya aap ise hindi me bana sakte hai?

@abdulsalam935 11 ай бұрын

Sir, Good Video. But, how to use this SYNTAX STRUCTURE in PREVIOUS VERSIONS OF EXCEL??

@jonr6680 11 ай бұрын

Afaik, it's not possible. It uses the new Filter Function. You would have to find an alternative method.

@paulmotion733 Ай бұрын

Is there a tutorial that uses Google Sheets?

@PKAnExcelExpert Ай бұрын

Please watch below given video: kzfaq.info/get/bejne/p7uIatCml5bQkYE.html

@rositoorquesta4271 28 күн бұрын

not usable to version without FILTER formula

@jbh.production 11 ай бұрын

Sir if we use numbers(like ids, employees id code)for search how we do that.

@PKAnExcelExpert 11 ай бұрын

Yes you can

@Frazeralmeida 5 ай бұрын

How can you memorize all this! My mind is not ready.

@RhetoricalLanguage 11 ай бұрын

at 16:38, it doesn't have all names containing 'Jan', please suggest the reason for this. thanks

@sumantgirase 9 ай бұрын

Because filter function has not yet been applied till that step..

@AboTrend 6 ай бұрын

what If I want to search by month and name ?

@PKAnExcelExpert 6 ай бұрын

We have changed the formula accordingly

@AboTrend 6 ай бұрын

@@PKAnExcelExpert I did same as ur video, but I can only search by specific column

@MAVERICK_098 10 ай бұрын

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

@BertiBIM-hf8wx 21 күн бұрын

sadly not reproducable in excel 2016

@Harshsanjana 11 ай бұрын

It is not works in excel 2019

@catttanor 8 ай бұрын

only 365

@ChhenPhina 11 ай бұрын

Why my excel don't have vstack function?

@abam9787 11 ай бұрын

VSTACK function is only available for *Microsoft 365* (both the desktop app and the web version)

@PKAnExcelExpert 11 ай бұрын

That's right

@oluwandetowoju6323 11 ай бұрын

I am using Excel 2021, is there any other function/formula I can use in place of VSTACK?

@abam9787 11 ай бұрын

@@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)

@khrisnaadi9766 10 ай бұрын

@@oluwandetowoju6323 try =TEXTJOIN to stacking rows