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

2 ай бұрын

I absolutely agree with you

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

9 ай бұрын

Thanks for your valuable feedback🙏

@sandeeppawar7939

7 ай бұрын

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

Simply Amazing!!! thanks so much PK :)

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

4 ай бұрын

Glad it was helpful!

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

@PKAnExcelExpert

6 ай бұрын

My pleasure!

Excellent use of the new Excel spill functions.

@PKAnExcelExpert

6 ай бұрын

Glad it was helpful!

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

@PKAnExcelExpert

9 ай бұрын

Most welcome🙏

This is impressive, thanks for sharing your knowledge ❤

@PKAnExcelExpert

9 ай бұрын

Most welcome🙏

Thank you so much sir. you are great people

@PKAnExcelExpert

9 ай бұрын

My pleasure

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

@PKAnExcelExpert

6 ай бұрын

Thanks for your valuable feedback 🙏

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

@PKAnExcelExpert

9 ай бұрын

That's right

Excellent tutorial

@PKAnExcelExpert

9 ай бұрын

Thanks🙏

Thank you so much, Sir.

@PKAnExcelExpert

9 ай бұрын

Most welcome🙏

This video is super useful!

@PKAnExcelExpert

7 ай бұрын

Glad you think so!

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

@PKAnExcelExpert

8 ай бұрын

Wow, thanks!

Fantastic!

@PKAnExcelExpert

2 ай бұрын

Many thanks!

Superb sir ❤

@PKAnExcelExpert

9 ай бұрын

Thanks🙏

Gazab......Sir

@PKAnExcelExpert

Ай бұрын

Thanks

soo cool - THANK YOU

@PKAnExcelExpert

8 ай бұрын

Most welcome🙏

amazing

@PKAnExcelExpert

2 ай бұрын

Thanks

Great

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

@PKAnExcelExpert

9 ай бұрын

Most welcome🙏

@Harshsanjana

9 ай бұрын

Sir any solution

@Harshsanjana

7 ай бұрын

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

that's so smart way 👏

@PKAnExcelExpert

9 ай бұрын

Thanks

You are amazing!]

@PKAnExcelExpert

6 ай бұрын

Thanks 🙏

it is great

@PKAnExcelExpert

9 ай бұрын

Thanks🙏

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

9 ай бұрын

Thanks for your valuable feedback🙏🙏🙏

@pandharinathjoshi6565

9 ай бұрын

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

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

8 ай бұрын

Good to know, thanks.

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

@PKAnExcelExpert

6 ай бұрын

Will create soon

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

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

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

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 please make ISP management project

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

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

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?

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?

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

@JeromeTiamson-gj5sj

8 ай бұрын

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

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

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

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

@PKAnExcelExpert

9 ай бұрын

Yes we can. We have to change the formula accordingly

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

8 ай бұрын

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

Please share this excel if multiple sheet with different headers

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

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

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

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

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😭

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

@PKAnExcelExpert

9 ай бұрын

will try to create

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

2 ай бұрын

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

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

4 ай бұрын

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

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.

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

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

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

@PKAnExcelExpert

9 ай бұрын

Yes we can. Try to add in next version

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

@jonr6680

9 ай бұрын

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

Is there a tutorial that uses Google Sheets?

@PKAnExcelExpert

9 күн бұрын

Please watch below given video: kzread.info/dash/bejne/o4mMmc-uYpPSkbA.html

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

@PKAnExcelExpert

9 ай бұрын

Yes you can

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.

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

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

@sumantgirase

8 ай бұрын

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

what If I want to search by month and name ?

@PKAnExcelExpert

4 ай бұрын

We have changed the formula accordingly

@AboTrend

4 ай бұрын

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

Why my excel don't have vstack function?

@abam9787

9 ай бұрын

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

@PKAnExcelExpert

9 ай бұрын

That's right

@oluwandetowoju6323

9 ай бұрын

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

@abam9787

9 ай бұрын

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

8 ай бұрын

@@oluwandetowoju6323 try =TEXTJOIN to stacking rows

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

It is not works in excel 2019

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

@sumantgirase

8 ай бұрын

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

4 ай бұрын

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

@aCatSiki

4 ай бұрын

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

only 365