If you found this video useful, please give it a thumbs up 👍 and subscribe to the channel. Also, let me know what Google Sheets topics you want me to cover in future videos.
Thanks for this video. This was very helpful. I just one question, in the filter we are selecting countries, what if I want to print ALL Unique countries value only. Say if Cell Reference is neither US, Australia or Canada instead ALL which is not a value in Countries field and then just print the Unique countries in the table when All is selected. Any help would be greatly appreciated.
Thanks for this. How would you handle doing an 'all' option. So, maybe you don't want *just* the US, Australia or the other countries but you want *all* of them? How would you do that?
Hello, I really love you explainations about filter formula. But i have an other issues about filter that which not discussed. Problem is this i have applied "double if " formula with single column e.g. Buy/sell. And i want to filter that things where these words mentioned with the help of formula . Kindly help me. Thank you
Is there a way to use filter and get only specific columns from the source range? For example, in your case, let's say I only want the name and the sales number, and don't want the Country information.
can you show how to appear only entered value or name for example in search box if i write hello and hit enter it will only show me the entered value and the rest should be hidden .. plz
If you found this video useful, please give it a thumbs up 👍 and subscribe to the channel. Also, let me know what Google Sheets topics you want me to cover in future videos.
Thanks for this video. This was very helpful. I just one question, in the filter we are selecting countries, what if I want to print ALL Unique countries value only. Say if Cell Reference is neither US, Australia or Canada instead ALL which is not a value in Countries field and then just print the Unique countries in the table when All is selected. Any help would be greatly appreciated.
This was so helpful! Thanks!
You made this complex formula so easy lol. You're the best.
Please make videos on date wise filter
Thanks for this. How would you handle doing an 'all' option. So, maybe you don't want *just* the US, Australia or the other countries but you want *all* of them? How would you do that?
Hello, I really love you explainations about filter formula. But i have an other issues about filter that which not discussed. Problem is this i have applied "double if " formula with single column e.g. Buy/sell. And i want to filter that things where these words mentioned with the help of formula . Kindly help me.
Thank you
Appreciate your explaining the Filter function. Do you have a video explaining how to combine the Filter with the Sort function?
Nice video no time wasted, you covered alot of material quickly and clearly
Glad you found it useful :)
how do you filter multiple selections in the same column? For example, using your video how would you filter Anna and Brazil?
Excellent tutorial video. I found this easy to understand and quite useful at work.
Is there a way to use filter and get only specific columns from the source range? For example, in your case, let's say I only want the name and the sales number, and don't want the Country information.
did you find any asnwer to this question.. I am also looking for same
thank you!
Glad you found it useful!
Can you show how to filter from multiple drop downs?
Great video - When running a filter and or query function -- my column is super long. How can I break it up so it makes 2 or 3 columns?
Is it possible to filter from date & to date in filter option
How would I filter even and odd number "fields" not rows?
How do you show only your data and remove all other non used cells / row?
can you show how to appear only entered value or name for example in search box if i write hello and hit enter it will only show me the entered value and the rest should be hidden .. plz
very useful for google sheet formula introduce
How do you filter by date? Say all the dates in the month of October or November?
when i use the less than filter in a sheet, there are multiple values are less than 5000 but it doesnt show those value
Amazing video
How do I filter partial text in a cell? For instance, if multiple cells had the same last name and I wanted to filter by the last name?
respect mi g
How would you do if you don't want to display the "Country" using the dropdown example and only the other two fields?
You should use the Query function if that’s the case!
How to filter a data from one sheet to another ??
I was really hoping Google hadn't made it so complicated compared to the check-box option you get when filtering on Excel... This is horrible..