Create a Dynamic Search Box in Excel to Find Anything within your Data!
ฝัง
- เผยแพร่เมื่อ 6 ก.ย. 2024
- In this video, I will show you a step-by-step guide how to create a Dynamic Search box to find anything within your Database in Excel.
Microsoft Excel is so versatile for analysing Data and it has a lot of functions that can help you stay productive at your workplace or business.
But, how do you search for Data within thousands of rows in one second?
In this video, I will show you how to stop the endless scrolling across columns and down the rows in Excel by creating a dynamic Search box that displays data as you type.
-This tutorial will also explain functions like FILTER, ISNUMBER and SEARCH functions in Excel.
- How to Insert and format Shapes and Stock images in Excel
- Conditional Formatting in Excel
🔽 CONNECT WITH ME
- Facebook: www.facebook.c...
- LinkedIn: www.linkedin.com/in/ruth-kingsley61147a136/
🔔 SUBSCRIBE ON TH-cam
youtube.com/@r...
#microsoftexcel #filterfunction #isnumber #searchfunction
Maam, please make a video using sumifs+xlookup+conditional formatting together in a table data
Thanks Ruth, would you mind sharing the file dor better practice?
Excellent.
Very helpful, thank you very much 🙂
Hi! I don’t have the Filter function in my Excel. Is there any other syntax for this?
Hello bisht,
I don't think there is another syntax for this.
You can try upgrading your Excel to the latest version to get the new functions. If you can get Excel 2021, the FILTER function will be available for you.
Thank you very much
Hi @@ElWensh89
Thank you so much 🙏
Thank you Ruth. I have used your tutorial for my search function. not sure how to secure the search sheet that the formula is not tamered with and so too for the columns i have of hyperlinks. could you advise?
Thank you so much, Guido 🙏
To protect your search sheet, or lock certain cells from unauthorized access, you can click on Review tab, check protect group and follow the guide from the dialog box.
Or you can watch this 5mins video to see how you can do it
th-cam.com/video/V1CIM5WEUM0/w-d-xo.htmlsi=N9Nt0VCH0qZX7NZ-
@@ruthkingsley1 Thank you for that tutorial. Unfortunately this is not going to help me completely. I will be setting the selections to allow the user to access, but locking the worksheet while allowing access to hyperlinks is not that easy. click once and you activate the hyperlink double click and you enter the hyperlink. this is where the fail is. The answer i believe is by VBA code where you limit the access to any hyperlink to one click only then you need to deactivate the hyperlink and then protect that cell. I am working on this theory.
My windows don't support filter formula? Have any other option?
Hello @@md.mazidhossian802,
I don't think there is another syntax for this.
I would suggest you upgrade your Excel to the latest version to get the new functions. If you can get Excel 2021, the FILTER function will be available for you.
Hello after this operation is done can we add more name and information?
Hello @@alansherzad9959
Yes, you can add more information to the table and use the search box to retrieve it.
thank you
Thank you so much, Athena 🙏
Thank you so much for your excellent explanation. I find that your explanation is a bit slow to fully understand.
Thank you Shg for the feedback.
Please let me know whichever part is confusing so I can help out.
I only tried to take it step by step so that anyone watching can fully understand at once
My excel doesn't have stock images in my insert picture tab, and my excel has only formula FILTERXML. Please help me out
In my version of office filter function is not valid
Hello Syed,
I used Excel 2021 for this video. The function is also available for Microsoft 365.
Older versions of Excel do not have this function. So maybe you can upgrade to the latest version to use it.
Hi, I had problem with this search bar as we share this excel file on server with my college.
When they tried to search, it show error. Could you share me how to fix this?
Thanks very much Ruth
Please can this trick work in 2016 version?
Hello Daniel,
The FILTER function is not available for older versions of Excel.
Microsoft says it is only available for Microsoft 365 and Excel 2021 Users.
You can upgrade your Excel version to use the function plus other newer Excel functions
Very informative Videos!
Thank you so much Abdul,
I'm glad you found it useful.
Thank you, very helpful.I will also get a heart please, please, please.
Thank you so much@@piokany8566 🙏
#VALUE! I try everything
Thank you so much@@sinsidet7137 🙏
Thank You
You're welcome Rabbe
Genius!
Thank you so much, Mirek
i love this thank you
Thank you so much, Learning Sphere
Thanks for the video. Could you kindly tell me the name of the mic you use to record the videos?
Hello Daxel,
Thank you so much.
I don't have a mic yet, I use my mobile device
Great video.
Thank you so much, Shakib
Good Day.what excel version do you use? Thanks
Hello Ernest,
I used Excel 2021 version for this.
Perfect Mdm please also share data file for better practice..
great tutorial!
but i'm just wondering where i get the Filter function and other function such us sort function & xlook-up from the add-ins?
anybody can tell to me😓
Thank you Kurt.
If you're using the new version of Excel, the new functions will be available for you to use. I don't think they can be added from any add-ins.
@@ruthkingsley1 I'm using 365 right now but I'm not sure if I can be able to use full features in my excel
He dear this is office 365 or microsoft office , because my office package excel does not include the " Filter " function ,please help me to solve this problem
Hello Tharaka,
I used Excel 2021 for this video. The function is also available for Microsoft 365.
Older versions of Excel do not have this function. So maybe you can upgrade to the latest version to use it.
it is great!
that's so good
Thank you so much 🙏
Nice
Thank you, Nazar
Pls help.. is it possible to edit after search?
Hello Nikola,
Yes it is possible..
does it works in excel 2016?
Hello Roldan,
The FILTER function is not available for older versions of Excel.
Microsoft says it is only available for Microsoft 365 and Excel 2021 Users.
You can upgrade your Excel version to use the function plus other newer Excel functions.
Great vlog sis thank you please I would love know how you record your video when you are working on your excel this is cause I want to create content for my LinkedIn please wat too did you use to make this recording I tried using screen record it was hanging my laptop
Thank you so much Kardii.
I use PowerPoint and Clipchamp. I have a video underway to show you how to use it.
Ooo that will be nice thank you so much
using the word set is not proper and confusing for users, what do you mean by set
is it a column or raw or what
Hello TheKarout12,
I'm sorry if my words were not very clear to you. If you listen closely, I said "Dataset" and not set.
Thank you!
How to Make this absolute function
Hello Ahmed,
That was a slight error.
It's an 'absolute reference' I meant that was why I added the Dollar sign to C2.
I applied all the steps, but it's says " that function isn't valid" 😥😥
Hello Mohamed,
The FILTER function is not available for older versions of Excel.
Microsoft says it is only available for Microsoft 365 and Excel 2021 Users.
That could be one of the reasons for that error. You can upgrade your Excel version to use the function plus other newer Excel functions
But if you're using the newer versions of Excel, let me know so I can help look into it.
@@ruthkingsley1 ahhaa i see, cause i have 2019 version !!
Any idea for this 2019 version ? 😊
Hello Mohamed,
I think it's just better to upgrade your Excel version or you can try out Microsoft 365, they usually have a free trial for few days.
For now, I don't think any function will give the exact and entire functionality of FILTER function.
@@ruthkingsley1
Please put a Sample Sheet Link to Download
what is c2 cell please ?
Hello Ahmad,
C2 is a cell in column C, row 2 in the worksheet.
So cell C2 was linked to the Search box in this video.
thank you
Thank you so much, Dell
does it works in excel 2016?
Yes true, function "FILTER" only available in office 365
thank you
thank you