New Excel Magic Search V2.0: Case-Sensitive Multi-Column Search!
HTML-код
- Опубликовано: 3 июн 2024
- #excelformula #exceltips #ExcelSearchBar
Hello Friends,
This the Magic Search Bar V2.0 in Excel. In this video, we have explained how to create a search bar in Excel to search across the multiple columns with the Case-Sensitive Search feature.
Watch the Magic Search Bar V1.0:
• Unlock Excel Secrets: ...
Subscribe our new RUclips Channel:
/ @neotechnavigators
Click below link to download the practice file:
www.pk-anexcelexpert.com/unlo...
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...
Magic Search's kindness is so impressive that it's enjoyable.
Thanks🙏
Thanks so much! This is awesome! I built a similar one using a different tutorial, but yours is simpler and nicer, so now I’m revising mine to this style. Thanks again! 😀
Great job PK! (From Canada)
Thanks🙏
Really a fantastic tutorial, thanks a lot for your time. Just a question: if in your sheet the items on one column contain also hyperlinks, how we need to modify the "dynamic" search formulas to copy also the hyperlink of eack line item filtered in the "data" sheet? Thanks in advance !
Excelente ING de lujo saludos maestro 👏👏👏🤝💯🇲🇽
Gracias
Fantastic tutorial. Learned a lot 🙏
Thanks🙏
Amazing, thanks PK for this video.
Thanks🙏
its awesome and impressive...... Hoping there is also a tutorial like this... using the google sheet
Once again amazing vid PK!! and thanks for sharing 😊
Most welcome🙏
Bro great very happy to see a pakistan's professional
Thank you very much for this great video 📹 😀 😊
Most welcome🙏
THANKS.. ITS WORKING GOOD. LEARNING GOOD
Glad to hear that
Finnaly this video has released, i have succesfull to try it,
Thanks PK❤
Most welcome🙏
Really good work. This is helpful for me.🤗
Thanks🙏
Exactly what I'm looking for
Thanks
Sir really great think
Great idea sir
Very smart done sir
Thanks🙏
Thanks a lot, very useful lesson
Most welcome🙏
Great tutorial, this is more better than lookup
Thanks🙏
thanks
Welcome
Nice! How do you proceed if you have first name and last name in different columns. Can you make an explanation video for this?
زبردست Excellent
Thanks🙏
Thank you so much.!
Most welcome
अद्भुत
Thank you so much, Sir.
Most welcome🙏
Outstanding video!! The data I'm using for this function is a list of website resources. All of the data in column "A" are hyperlinked. However, the filtered results on the search page are text only and NOT hyperlinked. Is there a way to keep the hyperlink in column A when searched on the different sheet? Thank you!!
hi! may i know if this will also capture the hyperlink embedded to the data?
thank you for the tutorial. i have tried it, alhamdulillah success. i wonder if the search data can be hyperlink. pls comment. thanks
Very good 👍👍👍
Thanks🙏
Amazing❤
Thanks🙏
Great! might be apply to Excel 2019 or later
For Excel 2021 and office 365
Awesome
Thanks🙏
Is there a way to use this for multiple tables across different sheets?
Wonderfull❤❤❤❤❤❤❤
Thanks
Any alternative to "Filter Function" as i am using older version of MS Excel.
Hi PK. This is helpful. When I add a link to the data, it disappears when I search it. Anything I can do to keep it?
I am very much fan of your Videos and Ideas, I have one request to you Please create micro that pick a PDF file path (it will be very ) in excel cell and combine togather in to marge PDF file. thanks in advance
I will try my best
@@PKAnExcelExpert Definitely we are existing
Hi. What if im still adding more rows in data as it will expand. Will the search still works?
Is there any video about multiple sheets search bar from multiple columns and in a search bar there should 2 drop down menu 1 for sheet name, and 2nd drop down for column name and a search bar to search a text?
Thank you, it's a great feature and I love it. Nevertheless, it seems that it doesn't work with numbers, right ?
Yes, exactly
Great video, can you please do a video on these search engines in google sheets thanks
Great suggestion! I will try to create a video on this topic.
if you have hyperlink in the data, how this can be show on the other sheet as well
Request you to provide vba for work allocation equally by employee order of cases should not change..looking for your response
if we have a lot of data, how can we add limit of rows to display the result and just add scroll bar in rows because I need it for printing. My rows is in fixed
which font use this projet
how can you search something and concatenate the result of surname, first name and middle name from 3 columns into 1 column?
Nice video indeed. How to search from individual columns in a dataset which will be controlled by checkbox with the column name??? Can you please help>???
will add this feature in next video. You can also see our previous video for single column search:
ruclips.net/video/w-tXwbYpr7I/видео.html
I am having difficulty getting this to look and work properly. I don't need the "Case sensitive" box, the actual search box text is super large, and I can't get it to change size. I am making a blank links list sheet to share with clients, so there is no data in the table as of yet. Will this cause a problem?
Great job … I would like to make something like that on google sheets. Let me know if it’s possible and show us how to make it.
Any update
will create a saparate video on this soon.
Can I link 3 dependent dropdown list with a searchbox to extract data?
Yes, we can. I will create a video on this
I'm using Excel 2019 and Filter function is not available, do you have an alternate code for FILTER?
Dear PK, can you make video on Run Time Error to set (RowSource), please
will try to create a video on this
Sir pls try food resturant management system vba software
Please watch the below video:
ruclips.net/video/xM_izKlWnew/видео.html
There is no cursor in the active control text box while i am typing, does anyone know how to fix it?
Hi I also want to create Search based result sheet for automobile field parts search via Part nonor Parts or parts description
Please watch the below video:
ruclips.net/video/OsdsJrzyjHg/видео.html
If I shared my sheet will you creat such search tool?
Hello, I bumped into a difficulty. Whenever I put in data, there's always one data missing. For example my data ends at row 7 but the search only shows up to row 6. I am so confused, I followed all the steps and it keeps happening. Thank you
Sir ye wala section complete ho jaye to pls food resturant management system software banao na uska video kisi ne bhi nahi banays he jese login rahe uske baad software run kare table wise order le uska ek print nikle kitchen me fir dinner k baad print nikle cash counter pe uska payment me opestion ho cash or online jisko jesa payment karna he kar sake or ha login me 2 type ka ho admin login kare to pura software run kar sake kuch bhi add karna he jese bill cancle karna ho ya food menu add karna ho it mins full assess or cashier login kare usko sirf bill nikla sake ot payment or sirf discount kar sake try karo pure RUclips me iska video mshi he kisi ne sochs hi nahi he is type ka main baat table jaruru banana konse table ks konsa order he warna mixup ho jayega pls try
Mind blowing explanation but little bit complicated for me😅😅😅
Thanks for your valuable feedback🙏
what version of excel? I do not have Filter function on mine. how can I add filter or alternative
It is in Excel 2021 and 365
Hello sir, what if i want to search for multiple keywords? is it possible with this method?
Yes, you can. I will try to create another video on this.
@@PKAnExcelExpert Thanks you so much, I will wait to see how you do this properly, because my method.. But i dont know, my method might be better then yours 😄
Also can you try to do it from other files? I want to create something like a database with a search, but i do not want to open the entire database just for a little search. The full idea is that in a folder i put multiple documents and the search doc will know that and will add to the database data that documents. Maybe I gave you some ideas for videos 😁
Hi sir can you show this working in Google sheet please
You can follow our other channel for Google sheet tutorials:
www.youtube.com/@NeotechNavigators
The problem i face in the two version is the calling of the range from Data - here you use concatenate(table1[name]... and the sheet picked it, my excel is not picking anything, I have tried many times
Any help on this pls
How can i resolve Value Error?
I have MS office 2019. The process is not feching all columns. Is there anything that could solve the problem?
FILTER function is available in office 2021 and office 365
I am getting Reference Invalid after adding the Linked Cell, Please help to resolve the same
This willwork in office 365 only
Sir pls one video food resturant management system software , one table order then cooy of print kitchn department , table order wise entry after lunch paid Bill print paid cash end drop down online entry , pls this type software pls provide with full vba create video
Sir mne esko office 365 me banaya h laptop me search wala proper work kar rha but mobile me " Excel doesn't support running or interacting with activeX control" ye error show ho rha h.
which office this is 2021 or 365?
365
I cannot find the video with the "search_text" formula, can you paste in here? =Filter(Data,SEARCH(Search_text... ???
Please watch the below video:
ruclips.net/video/w-tXwbYpr7I/видео.html
Sir, if I have multiple sheets then how will it work.
Will create it in the next version
@@PKAnExcelExpert It will be help full like dependent Sheet name wise or column wise.
You need to indicate what version of Excel, this is compatible with.
I tried it and it shows #NAME? in each cell.
Afaik it depends on 365 and uses the new filter function, which isn't available in earlier versions.
একটি ফোল্ডার থেকে অন্য একটি ফোল্ডারে কি ফর্মুলা ব্যবহার করা যাবে যদি করা যায় দয়া করে একটি ভিডিও আপলোড দেবেন প্লিজ
How to do in excel 2016
We need to use the VBA to do it in 2016. I will try to create.
Sir is it possible in search box
Always display like
“Search Here” or “Type Here”
Pls sir confirm sir how can we is there any VBA code sir
We can do this using vba code. Will try to do it in next version.
Sir if possible make short video for search box always display the Type here or Enter here sir
Its very use ful sir
Just now I have downloaded your sheet sir
Need code sir if possible sir pls
Sir pls upload sir
I am exiting to see in search bar
Text like Enter here or type here sir
I am not seen in any video sir
Concatenation not working
Sir, नीचे के कॉलम में 0 आ रहा है
Not clear