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.
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
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
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. :(
Hi And means the two conditions must be applied at the same time so in you case results will be rows when columns B and C contains whatever in cell g6. While or means only one condition is enough to retrieve the data.
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?
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?
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?
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?
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. ?
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?
The filtered data is just a shadow from the original, you are not supposed to edit it in the filter result, instead you should go to the main data source
@@askfarouk thank you for the reply, i was wondering how to add in values that have numbers such as the dates/salary into this formula as the concatenate only work with words
لو عندى عدة مبالغ وأريد أن أحدد من خﻻلها (مجموعة واحدة أو أكثر) من المبالغ التى إذا تم جمعها تحقق لى 1-قيمة معينة مثﻻ161جنيها 2- أقرب ناتج للقيمة المطلوبة سواء بالزيادة أو النقصان فهل يمكن تنفيذ ذلك بالاكسيل أو VBAو أرجوالرد ضرورى وشكرا للاهتمام
رائع استاذنا الفاضل. لي سؤال بعد اذنك. هل يوجد طريقه احسب بها اقات الصلاه بالاكسل. مثل اقوم بادخال خط الطول والعرض او النقطه الجغرافيه للموقع فيظهر عندي اوقات الصلاه؟ بحثت كثيرا ولم استطيع عمل مثل هذا. جزاك الله خيرا 🌹
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.
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.
Thanks for the positive feedback
👍👍❤️❤️ والله انت مبدع بحث في كل مكان عن هده الطريقة كل مرة اجد فلتر شكل وانت وضعت كل ما احتاج في فيديو واحد،
الله يجازيك كل خير،
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
Cheers mate. Just what i needed.
Thanks for the positive feedback
Thank you so much for making this video. it was exactly what I needed.
Thanks for your positive comment. I am glad it works for you.
TKS SOOOOO MUCH! THIS VIDEO HELP ME ALOT!!!!
Love you Thank you Jub Jub
Thank you so much for making this video. It was extremely helpful. I struggled with it for the last couple of days.
Thanks for the positive comment, I am glad it helps
Thank you soo much! it works
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.
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
Very simple an easy to understand. Thank you for sharing the knowledge
Thanks for the positive comment
I have created filter with 6 dropdown.
Thanks
Thanks for leaving the comment , I am happy it works
This is amazing 👌 you are soo smart 🧠. Thank you for sharing 👍
Thanks for the positive comment
how can i enable multi-selection in the dropdown?
Can you use this simultaeously with googlesheet slicer on the same sheet?
Wow! Thank you soooo much!
Thanks for the positive comments.
الشرح رائع و انا استفاد منه كتير في السابق
لكن في بعض التغييرات في جوجل شيت حاليا ممكن حضرتك تعمل فيديو جديد بالتحديثات الجديده
Can we add a date in drop down list?
Thanks!
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
Im having the same issue
I have also same Issue display date
Anyone any suggestion how to add the date filter?
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. :(
Hi
And means the two conditions must be applied at the same time so in you case results will be rows when columns B and C contains whatever in cell g6.
While or means only one condition is enough to retrieve the data.
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?
Can you help me? How can I combine more dates with the string concatenation function as you show in the video above?
Try text join or concate
ما شاء الله تبارك الرحمن ابداع كالمعتاد
هل يمكن الحصول على نفس الملف الذي أجريت عليه التجربة؟
أكرر شكري لك
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?
Hello
In this case we can use check box object to achieve this.
I like the idea , let m record it
Is there a way of, instead of choosing a dept from dropdown, to choose whether the cell is empty?
If i understand the question correctly, yes we can but the formula will be a little bit long
Will using this filter and query affect the view of other users?
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?
me too
What is the spreadsheet in the video description above supposed to be? Shouldn't it be the spreadsheet that you created in the video?
Sorry, can this work if the sheet is accessed simultaneously?
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?
Because it meay included in the range of the data.
Thank you for your positive comment
what if the data i wanted to filter also includes images? Since query doesn't work with pictures ?
Great question, we will record this for you
@@askfarouk Nice. thanks! I couldnt find a convenient way to do it
It works with picture, just use in line option when inserting the picture.
Sorry for the delay reply
Ok techer Ahmed
Do make lesson in access by English language?
Thank you very much
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. ?
sure we can and I tested it and it works fine.
I will record a video about it today.
thanks for the nice idea
@@askfarouk Wonderful!! Look forward to it. Thank you for doing this!
@@pattisakalauskas7946 ruclips.net/video/wfnvFqh3TGw/видео.html
Hi, I feel like I'm missing something...What is the difference/advantage of this method over just putting a filter at the header?
Hi
Filter on the header must be on the data
This filter can be implemented any place , even another sheet or another file.
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?
Thanks for the positive comment.
Check this for dates filter
ruclips.net/video/zSJklR1HGvA/видео.html
@@askfarouk Thank you! I will check it out!
how can I edit the filtered data
The filtered data is just a shadow from the original, you are not supposed to edit it in the filter result, instead you should go to the main data source
Wkx@@askfarouk
Hi could you show me how i can use the dropdown to edit by the dates like for example the hire date
ruclips.net/video/zSJklR1HGvA/видео.html
I hope this can help
@@askfarouk thank you for the reply, i was wondering how to add in values that have numbers such as the dates/salary into this formula as the concatenate only work with words
@@iantan4902 give me clear example , I will check
@@askfarouk hi i sent to your email
لو عندى عدة مبالغ وأريد أن أحدد من خﻻلها (مجموعة واحدة أو أكثر) من المبالغ التى إذا تم جمعها تحقق لى 1-قيمة معينة مثﻻ161جنيها 2- أقرب ناتج للقيمة المطلوبة سواء بالزيادة أو النقصان فهل يمكن تنفيذ ذلك بالاكسيل أو VBAو أرجوالرد ضرورى وشكرا للاهتمام
رائع استاذنا الفاضل.
لي سؤال بعد اذنك.
هل يوجد طريقه احسب بها اقات الصلاه بالاكسل.
مثل اقوم بادخال خط الطول والعرض او النقطه الجغرافيه للموقع فيظهر عندي اوقات الصلاه؟
بحثت كثيرا ولم استطيع عمل مثل هذا.
جزاك الله خيرا 🌹
فكرة حلوة ، خلينا نجرب
ruclips.net/video/ZMPfjlCxmms/видео.html
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.
I will check and I will update you.
@@askfarouk thank you! I’m just trying to understand how you copied the formula if you could help :)
docs.google.com/spreadsheets/d/1GnF5gNsQjCQUJ9lqcbRPDpu5HUTiFeojM9AOIU6ylgY/edit?usp=sharing
this copy is opened for edit through share so you can see the formula
@@askfarouk Thank you SOOOO much. You are a lifesaver. I just subscribed to you!!!
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.
I will check the video and sorry for your time, I think the code is attached to the video in the description box.
Linked file has been updated
Will it work with Excel the same way you do?