Excel: Create a Search Box in 3 Simple Steps!

Тәжірибелік нұсқаулар және стиль

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

Пікірлер: 94

  • @semolinasemolina8327
    @semolinasemolina83277 ай бұрын

    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
    @GiteshBajaj7 ай бұрын

    The way the results were presented were neat and clean.

  • @unnikrishnansanthosh
    @unnikrishnansanthosh9 ай бұрын

    superb, thank you for sharing

  • @6thOCT_BKK
    @6thOCT_BKK7 ай бұрын

    Thank you, it is very useful to me.

  • @humanbeing6294
    @humanbeing62947 ай бұрын

    Thank you very much! 🌿

  • @DAGL
    @DAGL8 ай бұрын

    thank you! muchas gracias!

  • @nepomuceno22
    @nepomuceno229 ай бұрын

    Muito THANK YOU

  • @belfire777
    @belfire7778 ай бұрын

    Thanks so much, hahah it says simple but i struggled but got there eventually. Subbed

  • @mohammedissaq7832
    @mohammedissaq78326 ай бұрын

    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!

  • @manoellopes8071
    @manoellopes80718 ай бұрын

    Thank you. Super.

  • @faitedata1617
    @faitedata16179 ай бұрын

    Thank you

  • @khushalsapariya9304
    @khushalsapariya93049 ай бұрын

    make more videos for data analysis skills to the next level!

  • @sherylleduna5367
    @sherylleduna53672 ай бұрын

    Thanks a lot!

  • @washingtonsilva4619
    @washingtonsilva46199 ай бұрын

    Realmente muito útil.

  • @user-il9xs4uj3z
    @user-il9xs4uj3z5 ай бұрын

    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

  • @cristann2668
    @cristann26684 ай бұрын

    Thank you so much

  • @InvierteenlaBolsadeValores
    @InvierteenlaBolsadeValores12 күн бұрын

    Muy bueno, excelente, un Inglés muy claro.

  • @abdiprastyagunawan
    @abdiprastyagunawan9 ай бұрын

    Cool bro. Great

  • @NETVN82

    @NETVN82

    9 ай бұрын

    Thanks for the visit

  • @kurd-pkpeace3029
    @kurd-pkpeace30292 ай бұрын

    Great 👍👍👍

  • @CatelloStefanoCavallaro
    @CatelloStefanoCavallaro9 ай бұрын

    Great

  • @shekarnerella8637
    @shekarnerella86376 ай бұрын

    Nice information

  • @abdulhamidalhaddadi2255
    @abdulhamidalhaddadi22558 ай бұрын

    What about the 2019 MS Excel? any formula can i use it instead of FILTER? thank you in advance

  • @EhsanComputerskills
    @EhsanComputerskills4 ай бұрын

    thank you

  • @eng.ummohamad
    @eng.ummohamad9 ай бұрын

    Thanks

  • @NETVN82

    @NETVN82

    9 ай бұрын

    Welcome

  • @niazianimalclinic
    @niazianimalclinic7 ай бұрын

    Which ms office version you are using

  • @umang28
    @umang289 ай бұрын

    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

  • @nemoyap
    @nemoyap9 ай бұрын

    💯👍

  • @juwelltoekimin4598
    @juwelltoekimin45986 ай бұрын

    Can you do this for multiple sheets?

  • @JohnKnorr
    @JohnKnorr6 ай бұрын

    This is great! How can I protect the sheet so that the search box is editable, but the formulas and data is locked down?

  • @adilfranco2923
    @adilfranco29233 ай бұрын

    THANKS

  • @hammoumabdelhakim1703
    @hammoumabdelhakim17039 ай бұрын

  • @user-du2mf4zj1p
    @user-du2mf4zj1p9 ай бұрын

    сам урок очень полезный но в исходниках нет формул которые используются в примере а на экране плохо видно можно формулы получить?

  • @francescot.neruda6855
    @francescot.neruda68559 ай бұрын

    🔝

  • @shahabshah6422
    @shahabshah64228 ай бұрын

    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

  • @ghiidee
    @ghiidee6 ай бұрын

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

  • @manjuannepam2082
    @manjuannepam20827 ай бұрын

    Can we search multiple data to show at one time????

  • @OSCARPION09
    @OSCARPION09Ай бұрын

    looks great but where did you post the query so I can copy and paste it into my sheet?

  • @salihcerci5841
    @salihcerci58417 ай бұрын

    Hey bro, How can i add filter function on my excel?

  • @waleedalqubati3849
    @waleedalqubati38497 ай бұрын

    😊We need also filter 2 worksheets into 1

  • @warisbg3647
    @warisbg36477 ай бұрын

    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

  • @mahah4256
    @mahah4256Ай бұрын

    Can I create a search box with an ongoing data set? As in I keep on adding data

  • @dionidiria3706
    @dionidiria37066 ай бұрын

    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.

  • @chathurangalakmal1655
    @chathurangalakmal16557 ай бұрын

    Please get me the step 2 full formular

  • @user-gw6cu8yx4z
    @user-gw6cu8yx4z3 ай бұрын

    what version of office this is? 2019?

  • @smrbakhshism2396
    @smrbakhshism23963 ай бұрын

    Hi, how to filter only number with vb code or a part of number in text box or cell value

  • @user-xs2yk3xw2r
    @user-xs2yk3xw2r2 ай бұрын

    how to display an image using the filter function?

  • @MirMdFaridtuddin
    @MirMdFaridtuddin7 ай бұрын

    After text box configuration the filter doesn't work.plz help

  • @BrumCraft
    @BrumCraft6 ай бұрын

    What would be much more useful is if it could search any column, not just column B

  • @huynhpham56
    @huynhpham569 ай бұрын

    Why doesn't my version of Excel have the fillter function

  • @NETVN82

    @NETVN82

    9 ай бұрын

    office 365

  • @russelgonzales6388
    @russelgonzales6388Ай бұрын

    hi, i tried to do this, but it only shows filterxml, what to do?

  • @amyusuf-xh2xz
    @amyusuf-xh2xz8 ай бұрын

    if i have hyperlink in table it will not work, how to make it work?

  • @WizardBrew
    @WizardBrew9 ай бұрын

    Slight correction viewers, there are lot of best videos in the channel. Enjoy them

  • @NETVN82

    @NETVN82

    9 ай бұрын

    Thanks for that!

  • @andre0000000007
    @andre00000000079 ай бұрын

    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

  • @michaelryanjereza5394
    @michaelryanjereza53942 ай бұрын

    how can we lock everything except for the search bar? thanks

  • @borislukic1590
    @borislukic15907 ай бұрын

    How to proteck everything, exept search cell?

  • @ReyZero
    @ReyZero9 ай бұрын

    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

  • @Eddrick-th5cn
    @Eddrick-th5cnАй бұрын

    Please hpw about 2013 excel that dont have filter function

  • @tomjones1502
    @tomjones15026 ай бұрын

    That "=TRUE" in formula it's not necessary. It enough "=FILTER(Data,ISNUMBER(SEARCH(B1,Data[SalesMan])),"Not found")"

  • @arendellehart6629
    @arendellehart66297 ай бұрын

    Pls do it in openoffice

  • @user-sx3jq4qr9q
    @user-sx3jq4qr9q18 күн бұрын

    Anwarhusain

  • @anggarahadian1728
    @anggarahadian17283 ай бұрын

    i cannot find the properties of the text box by right clicking

  • @jyveco.575
    @jyveco.5753 ай бұрын

    Why is =Filter not found in my excel

  • @games-by2fy
    @games-by2fy6 ай бұрын

    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

    2 ай бұрын

    is not available in 2019 too@@u_____u.

  • @piashasan2658
    @piashasan26587 ай бұрын

    Where is the sample file??

  • @ZiagiOnlineShopping
    @ZiagiOnlineShopping2 күн бұрын

    Filter not available 😢

  • @MissMayRandomposts
    @MissMayRandomposts5 ай бұрын

    My excel doesn't have the function "Filter" ,only FilterMax

  • @aravindpemmadi1052
    @aravindpemmadi10525 ай бұрын

    It would have been better if the data was not visible before entering anything in the search box.

  • @user-xx5wp3et1u
    @user-xx5wp3et1u4 ай бұрын

    what if theres no FILTER formula ?

  • @amet_tema93ru
    @amet_tema93ru9 ай бұрын

    Eblan ?

  • @TA3941
    @TA39419 ай бұрын

    FILTER PROBLEM FILTER XML

  • @IMORTALYANSEN
    @IMORTALYANSEN17 күн бұрын

    I m just Hinding Lol🤣🤣🤣

  • @user-xx5wp3et1u
    @user-xx5wp3et1u4 ай бұрын

    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

  • @SumanLafa
    @SumanLafa3 ай бұрын

    I didn’t get FILTER

  • @Hungry-dz-dz
    @Hungry-dz-dz9 ай бұрын

    Thank you for job ❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤

  • @NETVN82

    @NETVN82

    9 ай бұрын

    You're welcome 😊

Келесі