Тёмный

Excel: Create a Search Box in 3 Simple Steps! 

NETVN82
Подписаться 606 тыс.
Просмотров 218 тыс.
50% 1

In this video, you'll learn how to create a search box in Microsoft Excel.
Sample file bit.ly/3swHaYj
Subscribe now, it's free / netvn82
#netvn #excel #searchbox

Хобби

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

 

3 сен 2023

Поделиться:

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 94   
@semolinasemolina8327
@semolinasemolina8327 8 месяцев назад
can we all agree that when the music hits, It's actually as elative and emotional as the final scene in '4 weddings and a funeral' because everything is going to be all right, and then the casual aesthetics come in and the result is wonderful
@GiteshBajaj
@GiteshBajaj 8 месяцев назад
The way the results were presented were neat and clean.
@6thOCT_BKK
@6thOCT_BKK 8 месяцев назад
Thank you, it is very useful to me.
@humanbeing6294
@humanbeing6294 7 месяцев назад
Thank you very much! 🌿
@unnikrishnansanthosh
@unnikrishnansanthosh 9 месяцев назад
superb, thank you for sharing
@belfire777
@belfire777 8 месяцев назад
Thanks so much, hahah it says simple but i struggled but got there eventually. Subbed
@DAGL
@DAGL 9 месяцев назад
thank you! muchas gracias!
@nepomuceno22
@nepomuceno22 9 месяцев назад
Muito THANK YOU
@manoellopes8071
@manoellopes8071 8 месяцев назад
Thank you. Super.
@mohammedissaq7832
@mohammedissaq7832 6 месяцев назад
It's been 5 years and I'm looking for an equation that fits the nature of my work, and that's in front of me. Thank you.❤❤
@guddudas6672
@guddudas6672 Месяц назад
Help me
@guddudas6672
@guddudas6672 Месяц назад
Hey
@mohammedissaq7832
@mohammedissaq7832 Месяц назад
@guddudas6672 by what!
@khushalsapariya9304
@khushalsapariya9304 9 месяцев назад
make more videos for data analysis skills to the next level!
@faitedata1617
@faitedata1617 9 месяцев назад
Thank you
@InvierteenlaBolsadeValores
@InvierteenlaBolsadeValores 21 день назад
Muy bueno, excelente, un Inglés muy claro.
@sherylleduna5367
@sherylleduna5367 2 месяца назад
Thanks a lot!
@cristann2668
@cristann2668 4 месяца назад
Thank you so much
@user-il9xs4uj3z
@user-il9xs4uj3z 6 месяцев назад
This was very helpful in me creating a search engine. Could you advise how to secure the 'Search' worksheet when there are hyperlink columns in your search
@washingtonsilva4619
@washingtonsilva4619 9 месяцев назад
Realmente muito útil.
@shekarnerella8637
@shekarnerella8637 6 месяцев назад
Nice information
@kurd-pkpeace3029
@kurd-pkpeace3029 3 месяца назад
Great 👍👍👍
@CatelloStefanoCavallaro
@CatelloStefanoCavallaro 9 месяцев назад
Great
@abdiprastyagunawan
@abdiprastyagunawan 9 месяцев назад
Cool bro. Great
@NETVN82
@NETVN82 9 месяцев назад
Thanks for the visit
@abdulhamidalhaddadi2255
@abdulhamidalhaddadi2255 8 месяцев назад
What about the 2019 MS Excel? any formula can i use it instead of FILTER? thank you in advance
@EhsanComputerskills
@EhsanComputerskills 5 месяцев назад
thank you
@ghiidee
@ghiidee 6 месяцев назад
I'm using Excel 2019 and Filter function is not available, do you have an alternate code for FILTER?
@umang28
@umang28 9 месяцев назад
Hello can you help me how to get list of users(all domain user) from other server to secondary server (that contains shared folder only ) to set permissions for sharing folder
@adilfranco2923
@adilfranco2923 3 месяца назад
THANKS
@eng.ummohamad
@eng.ummohamad 9 месяцев назад
Thanks
@NETVN82
@NETVN82 9 месяцев назад
Welcome
@JohnKnorr
@JohnKnorr 6 месяцев назад
This is great! How can I protect the sheet so that the search box is editable, but the formulas and data is locked down?
@user-du2mf4zj1p
@user-du2mf4zj1p 9 месяцев назад
сам урок очень полезный но в исходниках нет формул которые используются в примере а на экране плохо видно можно формулы получить?
@hammoumabdelhakim1703
@hammoumabdelhakim1703 9 месяцев назад
@nemoyap
@nemoyap 9 месяцев назад
💯👍
@WizardBrew
@WizardBrew 9 месяцев назад
Slight correction viewers, there are lot of best videos in the channel. Enjoy them
@NETVN82
@NETVN82 9 месяцев назад
Thanks for that!
@niazianimalclinic
@niazianimalclinic 7 месяцев назад
Which ms office version you are using
@OSCARPION09
@OSCARPION09 2 месяца назад
looks great but where did you post the query so I can copy and paste it into my sheet?
@shahabshah6422
@shahabshah6422 8 месяцев назад
This is for the selected cells in 1 column. If we want to search from different sheets in multiple columns search what'll be the method for that also?
@juwelltoekimin4598
@juwelltoekimin4598 6 месяцев назад
Have you found your answer? I cant solve it
@juwelltoekimin4598
@juwelltoekimin4598 6 месяцев назад
Do you know how to search multiple sheets in 1 collumn
@varunakarniya
@varunakarniya 6 месяцев назад
I think you can use OR function in that case
@waleedalqubati3849
@waleedalqubati3849 7 месяцев назад
😊We need also filter 2 worksheets into 1
@dionidiria3706
@dionidiria3706 7 месяцев назад
Thank you for your knowledge, but in my Excel this formula doesn't work, it can't be run. what is this solution, thank you.
@juwelltoekimin4598
@juwelltoekimin4598 6 месяцев назад
Can you do this for multiple sheets?
@francescot.neruda6855
@francescot.neruda6855 9 месяцев назад
🔝
@BrumCraft
@BrumCraft 6 месяцев назад
What would be much more useful is if it could search any column, not just column B
@salihcerci5841
@salihcerci5841 7 месяцев назад
Hey bro, How can i add filter function on my excel?
@tomjones1502
@tomjones1502 6 месяцев назад
That "=TRUE" in formula it's not necessary. It enough "=FILTER(Data,ISNUMBER(SEARCH(B1,Data[SalesMan])),"Not found")"
@manjuannepam2082
@manjuannepam2082 8 месяцев назад
Can we search multiple data to show at one time????
@chathurangalakmal1655
@chathurangalakmal1655 8 месяцев назад
Please get me the step 2 full formular
@mahah4256
@mahah4256 2 месяца назад
Can I create a search box with an ongoing data set? As in I keep on adding data
@smrbakhshism2396
@smrbakhshism2396 4 месяца назад
Hi, how to filter only number with vb code or a part of number in text box or cell value
@warisbg3647
@warisbg3647 7 месяцев назад
How can I adjust the search so that I can filter my search not only by their names, but also from other attributes (such as items and sales based on this video) 🤔?
@varunakarniya
@varunakarniya 6 месяцев назад
I think you might have to use or function in that case, and put multiple conditions inside OR function
@ReyZero
@ReyZero 9 месяцев назад
No me funciono segui los plasos claro cambiando la formula del Ingles al español y no para nada me da error todas las veces, gran video
@MirMdFaridtuddin
@MirMdFaridtuddin 7 месяцев назад
After text box configuration the filter doesn't work.plz help
@user-xs2yk3xw2r
@user-xs2yk3xw2r 3 месяца назад
how to display an image using the filter function?
@andre0000000007
@andre0000000007 9 месяцев назад
i'm trying to do this with office 2000, it has table but i can't seem to select my data columns/rows. always gives me an error :(
@dre5229
@dre5229 9 месяцев назад
Filter is a new array formula. You need office 365. It’s been 2 weeks so this might be old news by now for you
@huynhpham56
@huynhpham56 9 месяцев назад
Why doesn't my version of Excel have the fillter function
@NETVN82
@NETVN82 9 месяцев назад
office 365
@Eddrick-th5cn
@Eddrick-th5cn 2 месяца назад
Please hpw about 2013 excel that dont have filter function
@russelgonzales6388
@russelgonzales6388 Месяц назад
hi, i tried to do this, but it only shows filterxml, what to do?
@borislukic1590
@borislukic1590 7 месяцев назад
How to proteck everything, exept search cell?
@amyusuf-xh2xz
@amyusuf-xh2xz 8 месяцев назад
if i have hyperlink in table it will not work, how to make it work?
@michaelryanjereza5394
@michaelryanjereza5394 2 месяца назад
how can we lock everything except for the search bar? thanks
@user-gw6cu8yx4z
@user-gw6cu8yx4z 3 месяца назад
what version of office this is? 2019?
@arendellehart6629
@arendellehart6629 8 месяцев назад
Pls do it in openoffice
@anggarahadian1728
@anggarahadian1728 3 месяца назад
i cannot find the properties of the text box by right clicking
@user-sx3jq4qr9q
@user-sx3jq4qr9q 28 дней назад
Anwarhusain
@TA3941
@TA3941 9 месяцев назад
FILTER PROBLEM FILTER XML
@aravindpemmadi1052
@aravindpemmadi1052 5 месяцев назад
It would have been better if the data was not visible before entering anything in the search box.
@jyveco.575
@jyveco.575 4 месяца назад
Why is =Filter not found in my excel
@games-by2fy
@games-by2fy 6 месяцев назад
there is no =FILTER ? i have excel 2016
@u_____u.
@u_____u. 4 месяца назад
Filter option is available in excel 2019 not in 2016
@aCatSiki
@aCatSiki 4 месяца назад
You need Office 365, I tried office 2021 and it didn't have it.
@xalidxelilov1827
@xalidxelilov1827 3 месяца назад
is not available in 2019 too@@u_____u.
@MissMayRandomposts
@MissMayRandomposts 5 месяцев назад
My excel doesn't have the function "Filter" ,only FilterMax
@amet_tema93ru
@amet_tema93ru 9 месяцев назад
Eblan ?
@ZiagiOnlineShopping
@ZiagiOnlineShopping 11 дней назад
Filter not available 😢
@piashasan2658
@piashasan2658 8 месяцев назад
Where is the sample file??
@user-xx5wp3et1u
@user-xx5wp3et1u 4 месяца назад
what if theres no FILTER formula ?
@IMORTALYANSEN
@IMORTALYANSEN 26 дней назад
I m just Hinding Lol🤣🤣🤣
@SumanLafa
@SumanLafa 3 месяца назад
I didn’t get FILTER
@user-xx5wp3et1u
@user-xx5wp3et1u 4 месяца назад
what if theres no FILTER formula
@u_____u.
@u_____u. 4 месяца назад
Filter formula is available in excel 2019 not in 2016
@aCatSiki
@aCatSiki 4 месяца назад
Update to Office 365
@Hungry-dz-dz
@Hungry-dz-dz 9 месяцев назад
Thank you for job ❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤
@NETVN82
@NETVN82 9 месяцев назад
You're welcome 😊
Далее
Excel : How to create a simple warehouse management
8:10
How to Create Pivot Table in Excel
20:49
Просмотров 1,1 млн
I Built 100 Homes And Gave Them Away!
09:36
Просмотров 30 млн
Say Goodbye to IF Statements in Excel with SWITCH
7:45
How to Make Search Bar in Excel (All Column Search)
11:37
How to Build Search Box in Excel
10:56
Просмотров 583 тыс.
Make a Search Bar in Excel to Find Anything!
10:35
Просмотров 315 тыс.
How to Create a Search Bar in Excel (in two minutes)
3:13
How to Create Tabs Within Tabs in Excel
10:34
Просмотров 68 тыс.
Как мы назвали малыша?
0:40
Просмотров 1,8 млн