Google Sheets FILTER - 5 tips for beginners🚀

[@panathenomad]

Soooo helpful! Thank you for this!

[@coupleracademy]

You're so welcome!

[@MFaa-dy7ko]

This video has been helped me. Thanks beautiful lady

[@MohamedRamadan-yp1tm]

Nice Anastasia. Thanks

[@klintbrown6507]

Will a Filter function work for doing a budget sheet? Basically, I have a budget, and when I mark one of the bills as "fully paid", I want the Gross Income, to subtract the dollar amount of the bill to give me my net income. But I am looking for it to be interactive and update as I choose the specific data selection.

[@abbesatty9498]

FILTER formula is used to filter and pull data. For operations on data you can use functions such as IF /OR/AND with - , + ,* and / operators. You can wrap it into ARRAYFORMULA formula and then fetch the filtered data with FILTER() or QUERY() afterward.

[@coupleracademy]

Yes, you can do it. I use it a lot for my personal budget as well. The simplest way is to use the next logic: =A1("my gross income") - SUM(FILTER(B1:B,C1:C="fully paid"). If you want to calculate taxes after (let's say 20% tax to be deducted), you can use =(A1 - SUM(FILTER(B1:B,C1:C="fully paid"))*0.8. 0.8=80% of net income. Hope this helps:)

[@pumeonguyen2301]

Hey I want to filter some specific columns but I have some other merged columns as well. When I tried to create filters it always said "You can't create a filter over a range containing vertical merges". Do googlesheet not allow us to create filter if we have merged columns? Then anyone has any ideas for solution? Please help!

[@coupleracademy]

Hey Pumeo. Indeed, merged cells are not filterable in Google Sheets. We also do not recommend using any merges in case you want to apply any formulas to your datasets. So the only way is to remove merges and use formulas. Merges are only good for static data when you want to have prettier/easier to read tables, but do not plan to perform any data analysis.

[@aishwaryajat2224]

Hey, I'm applying same formula but it's not showing the clients name. It is showing the #N/A please help me.

[@coupleracademy]

There might not be any values that match your criteria. You can also double check the punctuation, columns selected, the order of formula components, and your locale in File -> Spreadsheet settings. The symbols needed in each formula depend on the locale you choose.

[@goaliegod36]

This is a really helpful video! There's something that's killing me inside: 'Locale' is pronounced: /lōˈkal/ (like California) not /lōˈkāl/ (like the plante kale)

[@Felevr]

Amazing tutorial 👍

[@arminnasser]

thanks for the video. i wanna learn how to make a sheet for credit card that has payments, current date, annual interest rate, .... where can i learn than?

[@coupleracademy]

Hi Aaron. This depends on what kind of database you already have and in which source (is it in GSHeets or any other tool?). If you don't have a database yet, you can download the database (usually in .csv) from your account and open it in GSheets. And use FILTER to pull the columns you need. Let us know if we can help you.

[@Markd4Comment]

Did you use the filter function in one field, or dropped it down several? You got to demonstrate slower, and with detail. That detail can be simply going back and showing what was in the other fields.

[@coupleracademy]

We will do slower next time, thanks for your feedback. FILTER formula's output is a range of values, so you usually type a single formula at the beginning of your column and see the outputs below.

[@KissanServicesPakistan]

Good

[@futuresuperstar4life]

I JUST WANT TO KNOW HOW TO ADD A TAB THAT WILL FILTER MY DATES BY WEEK, BIWEEK, MONTH AND YEAR?!?! is this not possible?!?! It has to be because there are apps that do it!!! Maybe I just dont know how to look it up... PLEASE SOMEBODY HELPPP HEEEELLLP. IVE BEEN RESEARCHING THIS FOR DAYSSS

[@coupleracademy]

Try using formulas like: WEEKNUM() - the number of the week ISEVEN() - to see even numbers of the week MONTH() - shows the number of the month YEAR()

[@SELF213_]

How can I do this if I have players that cost money and have projections and I'm on a $60000 budget and trying to pick top players with high projections and not going over the $60000 budget.

[@coupleracademy]

if you simply want to see the list of all players sorted by the projections, you should use =SORT(FILTER(A2:C,B2:B

[@bengu1853]

Great video but the demonstrations were much too fast -- had to keep rewinding. Perhaps consider slowing it down a little in future videos :-)

[@coupleracademy]

Thanks for your feedback! We will try to slow it down :)

[@drn.iqbalsadiqi8824]

Hi

[@GaoMelly]

Query is a lot easier than filter function

[@coupleracademy]

In case you are familiar with SQL requests - yes. However, Filter formula has a very simple structure - WHAT you filter and BASED ON WHAT you filter. As for Query, it has a more complicated structure + you can't easily pull values from specific cells without a complicated syntax. With filter formula, you can refer to a specific cell or exact value much easier.

[@abbesatty9498]

Query is flexible and more powerful than filter, yes. easier , hell no! For Filter you only need to learn the intrinsic G Sheet formula syntax, but for QUERY, basic understanding of SQL is needed in order to use it efficiently .

[@THome92]

Visited the video for the Tutorial Stayed for the Lady Cus I am Joji

[@Markd4Comment]

And to hear the equal sign called a "quality sign" was odd. And don’t call the dollar sign an “S” please.

[@coupleracademy]

From Wikipedia: The equals sign or EQUALITY sign, =, is a mathematical symbol used to indicate equality in some well-defined sense.