Filter Google sheet Using dropdown list 

Was difficult to keep up with the logic but I understood enough! Thanks Farouk, works great. 👍👍👍👍

So far, this video is the most convenient way to get a drop-down menu with a filter function that included an "All" criteria. Thank you so much.

👍👍❤️❤️ والله انت مبدع بحث في كل مكان عن هده الطريقة كل مرة اجد فلتر شكل وانت وضعت كل ما احتاج في فيديو واحد، الله يجازيك كل خير،

What a legend. I tried Gemini and Bing AI to explain how to do this. Both failed miserably. But you explained it so well ⭐💖

Thank you so much for a very clear and helpful video.

GOOD JOB ,YOU HELPED ME A LOT ON A PROJECT

Very simple an easy to understand. Thank you for sharing the knowledge

Thank you so much for making this video. it was exactly what I needed.

Thank you so much for making this video. It was extremely helpful. I struggled with it for the last couple of days.

what if i want this dropdown list for the filter to be in the spread sheet it self. Is it possible? because i don't want to go to the other sheet for filtering i want everything should be in one sheet only which is main spread sheet. so i can edit there and add more data into it and in the same time i can filter if i need to.

TKS SOOOOO MUCH! THIS VIDEO HELP ME ALOT!!!!

isnt there a way to do this without programming? I want to do an tv series episode watch list with the drop downs being the tv series / season/ episode/ date watched. after rI finish an episode I want to update the date

Cheers mate. Just what i needed.

how can i enable multi-selection in the dropdown?

Thank you soo much! it works

Love you Thank you Jub Jub

Can you use this simultaeously with googlesheet slicer on the same sheet?

Sorry, can this work if the sheet is accessed simultaneously?

What is the spreadsheet in the video description above supposed to be? Shouldn't it be the spreadsheet that you created in the video?

Will using this filter and query affect the view of other users?

Thanks this was very cool BUT didn't work with numbers in columns. I tried converting data and UNIQUE lists to numbers and currency to match the search BUT when choosing columns with numbers the filter returned nothing. Any ideas?

This is amazing 👌 you are soo smart 🧠. Thank you for sharing 👍

Thanks!

Can we add a date in drop down list?

الشرح رائع و انا استفاد منه كتير في السابق لكن في بعض التغييرات في جوجل شيت حاليا ممكن حضرتك تعمل فيديو جديد بالتحديثات الجديده

Wow! Thank you soooo much!

Hi there! Im having some trouble with my query function as I want to search by text (name or last name columns) and this is what I tried: =IF(G6=""; QUERY('Info. '!A3:L;"SELECT *");QUERY('Info. '!A3:L;"SELECT * WHERE B LIKE '%"&G6&"%' AND C LIKE '%"&G6&"%'")) Is the problem about using AND instead of OR? In these two options the searching doesn't work. :(

Thanks man! Very compolicated but you made it easy. One question, Why does my header row disappear when I do the filtering? Also in my data range on the first column the entries have links to a different spreadsheet but with this method the result from the filtering doesn't have the links. Can I make the first column to include the links on the entries?

Can you help me? How can I combine more dates with the string concatenation function as you show in the video above?

Hello, Is there a way to be able to select multiple criteria in one drop down? For example if you wanted to filter by two departments on your spreadsheet vs just one department at a time?

This is great - what if I wanted to do this filter by date range? (for example, on your spreadsheet, using the hire date as a filter) The problem I think I'm having is that the date (displayed as a date) gets jumbled into the number representation of the date and so the data isn't properly recognized

Is there a way of, instead of choosing a dept from dropdown, to choose whether the cell is empty?

ما شاء الله تبارك الرحمن ابداع كالمعتاد هل يمكن الحصول على نفس الملف الذي أجريت عليه التجربة؟ أكرر شكري لك

Ok techer Ahmed Do make lesson in access by English language? Thank you very much

Hi! I followed your tutorial and am using your guide. When I have two dropdown filters, it works fine. When I try and add three, it doesn't work and I get a #VALUE! error. Any advice?

Thank you so much! This really works for what I'm looking for. Question, if I want to filter by between two dates (2 weeks). What would the code looks like?

Hi, I feel like I'm missing something...What is the difference/advantage of this method over just putting a filter at the header?

Thanks for your reply - is there a way to re-set all back to All (I have 6) without doing it individually? Also - can you search on basis of a number? As in if a column is greater than $5000. ?

what if the data i wanted to filter also includes images? Since query doesn't work with pictures ?

I have created filter with 6 dropdown. Thanks

لو عندى عدة مبالغ وأريد أن أحدد من خﻻلها (مجموعة واحدة أو أكثر) من المبالغ التى إذا تم جمعها تحقق لى 1-قيمة معينة مثﻻ161جنيها 2- أقرب ناتج للقيمة المطلوبة سواء بالزيادة أو النقصان فهل يمكن تنفيذ ذلك بالاكسيل أو VBAو أرجوالرد ضرورى وشكرا للاهتمام

Hi could you show me how i can use the dropdown to edit by the dates like for example the hire date

how can I edit the filtered data

رائع استاذنا الفاضل. لي سؤال بعد اذنك. هل يوجد طريقه احسب بها اقات الصلاه بالاكسل. مثل اقوم بادخال خط الطول والعرض او النقطه الجغرافيه للموقع فيظهر عندي اوقات الصلاه؟ بحثت كثيرا ولم استطيع عمل مثل هذا. جزاك الله خيرا 🌹

Why is there a jump cut at 9:38? Its very confusing how you got to the next step with the formula at that timecode.

Got through the whole thing, taking 30 minutes, but right at the end, you skipped the instructions. You deleted code and said "If I try this condition..." You did something without explaining.

Will it work with Excel the same way you do?