The Google Sheets FILTER function assists you to extract specific data, for
example, from a bank statement. For instance, if you want to extract the
amount like savings account interest, fixed deposit (FD) interest, and other income, to compute income, say for filing income tax return, the FILTER function is a powerful function for this task.

-------------------------------------
The FILTER function is a powerful function to extract data, based on one
or more conditions:

[ Ссылка ]

Play the Google Sheets function name Jumble game. It has scrambled function names. All you have to do is to unscramble the names:

[ Ссылка ]

Google Sheets Quiz with Demo of Answers

Try this 5-question quiz, which also demos the answers. The quiz
can be helpful in your day-to-day spreadsheet work or for job interview:

[ Ссылка ]
-------------------------------------

Here is the format of the FILTER function formula:

=FILTER(range, condition1, [condition2], […])

Start the formula with an equal-to symbol.

FILTER is the name of the function.

range is the range from which to extract the data.

condition1 is the condition to extract the data.

condition2, and subsequent conditions, is/are optional.

Let's look at an example of the FILTER function formula:

=FILTER(B2:B11, A1:A11="interest")

The above formula will extract that data, from the range B2 to B11, corresponding to the text "interest" in the range A1 to A11. This is assuming the said text is found.

Review this video, which gives the steps to use the Google Sheets FILTER function to extract specific data, with examples.

свернуть