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

[@skenming]

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]

I absolutely agree with you

[@jimfitch]

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]

Glad it was helpful!

[@Chef-1707]

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]

Thanks for your valuable feedback🙏

[@sandeeppawar7939]

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

[@donbogdala5428]

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

[@PKAnExcelExpert]

My pleasure!

[@gorflunk]

Excellent use of the new Excel spill functions.

[@PKAnExcelExpert]

Glad it was helpful!

[@southisacknova]

Thank you so much sir. you are great people

[@PKAnExcelExpert]

My pleasure

[@HappyMainer]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback 🙏

[@nunogomes694]

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

[@PKAnExcelExpert]

Most welcome

[@lorenzocancer]

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

[@PKAnExcelExpert]

Most welcome🙏

[@AmitSingh-kb4xr]

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

[@PKAnExcelExpert]

Wow, thanks!

[@vijaysahal4556]

Superb sir ❤

[@PKAnExcelExpert]

Thanks🙏

[@mohamadsiddeek7912]

Excellent tutorial

[@PKAnExcelExpert]

Thanks🙏

[@hichamhadj9640]

This is impressive, thanks for sharing your knowledge ❤

[@PKAnExcelExpert]

Most welcome🙏

[@vacilando86]

that's so smart way 👏

[@PKAnExcelExpert]

Thanks

[@petzlica]

This video is super useful!

[@PKAnExcelExpert]

Glad you think so!

[@MohAboAbdo]

Thank you so much, Sir.

[@PKAnExcelExpert]

Most welcome🙏

[@Harshsanjana]

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

[@PKAnExcelExpert]

Most welcome🙏

[@Harshsanjana]

Sir any solution

[@Harshsanjana]

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

[@zaydarendse2812]

Simply Amazing!!! thanks so much PK :)

[@HasnainSabir-y1i]

SUPERB

[@PKAnExcelExpert]

Thanks

[@christoph231090]

soo cool - THANK YOU

[@PKAnExcelExpert]

Most welcome🙏

[@KrishnaKumar-zn9kg]

Fantastic!

[@PKAnExcelExpert]

Many thanks!

[@zeeshanzeenu]

Gazab......Sir

[@PKAnExcelExpert]

Thanks

[@abam9787]

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

[@PKAnExcelExpert]

That's right

[@usman6857]

amazing

[@PKAnExcelExpert]

Thanks

[@pandharinathjoshi6565]

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]

Thanks for your valuable feedback🙏🙏🙏

[@pandharinathjoshi6565]

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

[@joseelizondo373]

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

[@PKAnExcelExpert]

Will create soon

[@musatenginkeri1823]

Great

[@suleymanturkmen2748]

it is great

[@PKAnExcelExpert]

Thanks🙏

[@mcegirl4]

You are amazing!]

[@PKAnExcelExpert]

Thanks 🙏

[@sumantgirase]

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

[@qasimawan3568]

Good to know, thanks.

[@KidGalahad67]

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

[@khalidmounir3475]

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

[@syedsalman1559]

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

[@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?

[@Dan_De_Man]

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

[@meetdave6952]

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.

[@dothework413]

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

[@JeromeTiamson-gj5sj]

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

[@JeromeTiamson-gj5sj]

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

[@NGUONVANRADY]

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

[@EM-GAMER-YT]

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

[@sumantgirase]

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]

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

[@aCatSiki]

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

[@Puerto_Ayacucho_VE]

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]

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?

[@dhanishpk]

Thanks you nice one ,but VBA search bar is not working if we share the file through share point ( "excel for the Web does not support" ) ,any solution for the same

[@MirMdFariduddin1980]

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

[@girishpadshala9689]

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

[@PKAnExcelExpert]

Yes we can. We have to change the formula accordingly

[@anupamsarkar5882]

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.

[@marvinaceroque3790]

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

[@bsnlftth69]

sir please make ISP management project

[@ghiidee]

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

[@diya2909]

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

[@PKAnExcelExpert]

Yes we can. Try to add in next version

[@markanthonycruzatcruzat6068]

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

[@yahyaramadhan2698]

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

[@PKAnExcelExpert]

will try to create

[@sharad24agrawal]

Please share this excel if multiple sheet with different headers

[@saadkamran1729]

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

[@Sean9243]

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?

[@RhetoricalLanguage]

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

[@sumantgirase]

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

[@paulmotion733]

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

[@MT-pe4pm]

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.

[@shaheervalappil3838]

Can u Pls explain pk

[@nadermounir8228]

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

[@mohammadsafiqulislam5779]

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?

[@qasimawan3568]

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

[@jbh.production]

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

[@PKAnExcelExpert]

Yes you can

[@aravindpemmadi1052]

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

[@Harshsanjana]

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

[@samprime3180]

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

[@paulmotion733]

Is there a tutorial that uses Google Sheets?

[@PKAnExcelExpert]

Please watch below given video: kzbin.info/www/bejne/p4a7aKCrZ5Wfl68

[@Flo_la]

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]

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

[@abdullahquhtani8058]

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]

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

[@rositoorquesta4271]

not usable to version without FILTER formula

[@kurtmadronero-n5e]

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😭

[@ChhenPhina]

Why my excel don't have vstack function?

[@abam9787]

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

[@PKAnExcelExpert]

That's right

[@oluwandetowoju6323]

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

[@abam9787]

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

@@oluwandetowoju6323 try =TEXTJOIN to stacking rows

[@abdulsalam935]

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

[@jonr6680]

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

[@rajamit136]

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

[@asifhossain8605]

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.

[@AboTrend]

what If I want to search by month and name ?

[@PKAnExcelExpert]

We have changed the formula accordingly

[@AboTrend]

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

[@MAVERICK_098]

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

[@Frazeralmeida]

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

[@bs2-n]

Avoid using filter function as some has only office 2010 or older so your version is not compatible with what we have.

[@Harshsanjana]

It is not works in excel 2019

[@BertiBIM-hf8wx]

sadly not reproducable in excel 2016

[@sujitpal3381]

The discussion is definitely helpful. But whatever had been shown is purely FILTER. Kindly do not tag it as SEARCH else searching for genuine EXCEL SEARCH topic in KZbin will be misleading!!!

[@catttanor]

only 365