Excel: Create a Search Box in 3 Simple Steps!

[@semolinasemolina8327]

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

[@mohammedissaq7832]

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]

Help me

[@guddudas6672]

Hey

[@mohammedissaq7832]

@guddudas6672 by what!

[@taisertown]

Subhan Allah sir very well I would really like to appreciate your kind and dynamic efforts to make us easy this function

[@abdulhamidalhaddadi2255]

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

[@GiteshBajaj]

The way the results were presented were neat and clean.

[@alexandermckoy6444]

This is amazing!

[@RanjithaKannan]

Thank you very much. Exceptional and helpful video❤

[@querrythis]

Thanks for the hlelp. Very useful for eliminating worksheet clutter

[@GuidoBusuttil-h2h]

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

[@humanbeing6294]

Thank you very much! 🌿

[@shahabshah6422]

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]

Have you found your answer? I cant solve it

[@juwelltoekimin4598]

Do you know how to search multiple sheets in 1 collumn

[@varunakarniya]

I think you can use OR function in that case

[@kambizradman7378]

clear and efficient, awesome

[@ghiidee]

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

[@ibnuwinskaskus5684]

Seems like me, FILTER only FILTERXML, can anybody help me to create same function like this FILTER

[@ilovehouse23]

@@ibnuwinskaskus5684 same here :(

[@WizardBrew]

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

[@NETVN82]

Thanks for that!

[@ersingungor6101]

perfect explanation

[@belfire777]

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

[@manoellopes8071]

Thank you. Super.

[@khushalsapariya9304]

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

[@JohnKnorr]

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

[@dionidiria3706]

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.

[@Chipcookie1111]

Thank you very much!!

[@OSCARPION09]

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

[@DAGL]

thank you! muchas gracias!

[@abdiprastyagunawan]

Cool bro. Great

[@NETVN82]

Thanks for the visit

[@warisbg3647]

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]

I think you might have to use or function in that case, and put multiple conditions inside OR function

[@shekarnerella8637]

Nice information

[@cristann2668]

Thank you so much

[@tomjones1502]

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

[@InvierteenlaBolsadeValores]

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

[@huynhpham56]

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

[@NETVN82]

office 365

[@mastershonobi110]

Is there another way to bind /link the cell without using the text property in the developer tab? My current dev property in excel for text box does not have this “linked cell” option! Ugh

[@andre0000000007]

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]

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

[@BrumCraft]

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

[@juwelltoekimin4598]

Can you do this for multiple sheets?

[@sherylleduna5367]

Thanks a lot!

[@nepomuceno22]

Muito THANK YOU

[@первый-я4ю]

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

[@kurd-pkpeace3029]

Great 👍👍👍

[@manjuannepam2082]

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

[@unnikrishnansanthosh]

superb, thank you for sharing

[@games-by2fy]

there is no =FILTER ? i have excel 2016

[@xledits-w8c]

Filter option is available in excel 2019 not in 2016

[@aCatSiki]

You need Office 365, I tried office 2021 and it didn't have it.

[@xalidxelilov1827]

is not available in 2019 too@@xledits-w8c

[@mahah4256]

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

[@johncarloabante3950]

how did the B1 becomes $B$1? did you input it manually or it just comes out?

[@smrbakhshism2396]

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

[@waleedalqubati3849]

😊We need also filter 2 worksheets into 1

[@dimscab9952]

Greetings. Merci pour votre vidéo très édifiante. Pourrais-je avoir le fichier lui-même s'il vous plaît? Merci d'avance

[@chathurangalakmal1655]

Please get me the step 2 full formular

[@umang28]

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

[@salihcerci5841]

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

[@6thOCT_BKK]

Thank you, it is very useful to me.

[@MirMdFariduddin1980]

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

[@Memymine-y1s]

Bro what have you done at 2:16 how's your formula changed why doesn't it work for me....

[@niazianimalclinic]

Which ms office version you are using

[@minhduclai2133]

Office 365 full activation

[@Emotionsarewithus]

thank you

[@StevenSanjaya-c6l]

how to display an image using the filter function?

[@michaelryanjereza5394]

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

[@Eddrick-th5cn]

Please hpw about 2013 excel that dont have filter function

[@anonymousx1857]

When I try to add new data, it doesn't update and when I try searching in bar, it does appear

[@borislukic1590]

How to proteck everything, exept search cell?

[@eng.ummohamad]

Thanks

[@NETVN82]

Welcome

[@Ridhohid4y4t]

Coba kasih penjelasan lebih detailnya Om, dari tahap apa yang harus di ketik dan apa yang harus di klik ketua rumus berubah seperti di video karena sampai sekarang saya mencobanya belum berhasil juga

[@andokoputro6395]

tanya bang ... mengapa rumus =filter tidak muncul yang ada =filterXML

[@firjatullah1723]

what if theres new data? can it still be found?

[@CatelloStefanoCavallaro]

Great

[@info.searcher]

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

[@Ridhohid4y4t]

Bagaimana bisa =Filter(Data,Data[SalesMan]

[@russelgonzales6388]

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

[@ibnuwinskaskus5684]

Seems like me, have you get the alternate solution with another function?

[@SandriSaputra-o5y]

what version of office this is? 2019?

[@hammoumabdelhakim1703]

❤

[@anggarahadian1728]

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

[@YAMMO-OFFICIAL]

Gimana caranya agar muncul 1 nama saja tidak semuanya

[@ReyZero]

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

[@MissMayRandomposts]

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

[@Windows818]

Cool

[@faitedata1617]

Thank you

[@jyveco.575]

Why is =Filter not found in my excel

[@aravindpemmadi1052]

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

[@washingtonsilva4619]

Realmente muito útil.

[@nemoyap]

💯👍

[@_-wv4ez]

For an empty file sample. :(

[@asking-h2d]

what if theres no FILTER formula ?

[@ZiagiOnlineShopping]

Filter not available 😢

[@piashasan2658]

Where is the sample file??

[@joeleoalex6196]

Don't what to type after =filter?

[@francescot.neruda6855]

🔝

[@dervon.rodriguez]

This doesn't work...I put in the function and I can't search in B1

[@adilfranco2923]

THANKS

[@arendellehart6629]

Pls do it in openoffice

[@asking-h2d]

what if theres no FILTER formula

[@xledits-w8c]

Filter formula is available in excel 2019 not in 2016

[@aCatSiki]

Update to Office 365

[@अनवारहुसैनसनापनवाबइसमाहिल]

Anwarhusain

[@TA3941]

FILTER PROBLEM FILTER XML

[@IMORTALYANSEN]

I m just Hinding Lol🤣🤣🤣

[@SumanLafa]

I didn’t get FILTER

[@marrietaantone]

Not working

[@amet_tema93ru]

Eblan ?

[@berrysulaiman8409]

Lol khusus online office baru ada rumus filter

[@BawasluPessel]

minta fail jadi nya bang

[@salehalizadehyt]

cool 🔥🤍

[@Hungry-dz-dz]

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

[@NETVN82]

You're welcome 😊