Create a Dynamic Search Box in Excel to Find Anything within your Data!

Подписаться 1,8 тыс.

Просмотров 40 тыс.

50% 1

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: sumptious.sq...
- LinkedIn: www.linkedin.com/in/ruth-kingsley61147a136/
🔔 SUBSCRIBE ON RU-vid
youtube.com/@ruthkingsley1?si...
#microsoftexcel #filterfunction #isnumber #searchfunction

Опубликовано:

18 окт 2023

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 61

@athenalouise4019 15 дней назад

thank you

@ruthkingsley1 15 дней назад

Thank you so much, Athena 🙏

@XLcollegeUg 5 месяцев назад

i love this thank you

@ruthkingsley1 5 месяцев назад

Thank you so much, Learning Sphere

@user-el1jb4gj9s 6 месяцев назад

it is great!

@AbdulRehman-ce8lx 5 месяцев назад

Very informative Videos!

@ruthkingsley1 5 месяцев назад

Thank you so much Abdul, I'm glad you found it useful.

@shakibishfaq8627 8 месяцев назад

Great video.

@ruthkingsley1 8 месяцев назад

Thank you so much, Shakib

@rabbeislam7468 8 месяцев назад

Thank You

@ruthkingsley1 8 месяцев назад

You're welcome Rabbe

@mirekkryskapriv7445 6 месяцев назад

Genius!

@ruthkingsley1 6 месяцев назад

Thank you so much, Mirek

@IcanDothisALLdayyy 8 месяцев назад

that's so good

@ruthkingsley1 8 месяцев назад

Thank you so much 🙏

@nazarkamal8831 7 месяцев назад

Nice

@ruthkingsley1 7 месяцев назад

Thank you, Nazar

@usmaniqbal1836 7 месяцев назад

Perfect Mdm please also share data file for better practice..

@user-il9xs4uj3z 6 месяцев назад

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?

@ruthkingsley1 6 месяцев назад

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 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-V1CIM5WEUM0.htmlsi=N9Nt0VCH0qZX7NZ-

@user-il9xs4uj3z 6 месяцев назад

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

@daXcel7448 8 месяцев назад

Thanks for the video. Could you kindly tell me the name of the mic you use to record the videos?

@ruthkingsley1 8 месяцев назад

Hello Daxel, Thank you so much. I don't have a mic yet, I use my mobile device

@user-ks8gy4sk9k 4 месяца назад

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?

@user-bo9lb3we2p 8 месяцев назад

Thanks very much Ruth Please can this trick work in 2016 version?

@ruthkingsley1 8 месяцев назад

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

@user-kv7uk5yd5v 4 месяца назад

does it works in excel 2016?

@kardiiobi321 8 месяцев назад

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

@ruthkingsley1 8 месяцев назад

Thank you so much Kardii. I use PowerPoint and Clipchamp. I have a video underway to show you how to use it.

@kardiiobi321 8 месяцев назад

Ooo that will be nice thank you so much

@user-hn3gz2xb1e 8 месяцев назад

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😓

@ruthkingsley1 8 месяцев назад

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.

@user-hn3gz2xb1e 8 месяцев назад

@@ruthkingsley1 I'm using 365 right now but I'm not sure if I can be able to use full features in my excel

@ernestlorenzoursua 3 месяца назад

Good Day.what excel version do you use? Thanks

@ruthkingsley1 3 месяца назад

Hello Ernest, I used Excel 2021 version for this.

@Shng1968 7 месяцев назад

Thank you so much for your excellent explanation. I find that your explanation is a bit slow to fully understand.

@ruthkingsley1 7 месяцев назад

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

@Shng1968 7 месяцев назад

My excel doesn't have stock images in my insert picture tab, and my excel has only formula FILTERXML. Please help me out

@Tharaka797 5 месяцев назад

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

@ruthkingsley1 5 месяцев назад

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.

@syedakhterhussain6135 25 дней назад

In my version of office filter function is not valid

@ruthkingsley1 25 дней назад

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.

@johngraholini5475 6 месяцев назад

Pls help.. is it possible to edit after search?

@ruthkingsley1 6 месяцев назад

Hello Nikola, Yes it is possible..

@ahmedrizk9276 4 месяца назад

How to Make this absolute function

@ruthkingsley1 4 месяца назад

Hello Ahmed, That was a slight error. It's an 'absolute reference' I meant that was why I added the Dollar sign to C2.

@TheKarout12 8 месяцев назад

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

@ruthkingsley1 8 месяцев назад

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!

@mohamedslimane2697 7 месяцев назад

I applied all the steps, but it's says " that function isn't valid" 😥😥

@ruthkingsley1 7 месяцев назад

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.

@mohamedslimane2697 7 месяцев назад

@@ruthkingsley1 ahhaa i see, cause i have 2019 version !! Any idea for this 2019 version ? 😊

@ruthkingsley1 7 месяцев назад

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.

@iZacq 2 месяца назад

@@ruthkingsley1 Please put a Sample Sheet Link to Download

@0500902076 4 месяца назад

what is c2 cell please ?

@ruthkingsley1 4 месяца назад

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.

@user-ef5nr1ps6w 8 месяцев назад

thank you

@user-kv7uk5yd5v 4 месяца назад

does it works in excel 2016?

@ruthkingsley1 4 месяца назад

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.

@user-ef5nr1ps6w 8 месяцев назад

thank you

@user-ef5nr1ps6w 8 месяцев назад

thank you

@ruthkingsley1 8 месяцев назад

Thank you so much, Dell