Learn to use the powerful Google Sheets FILTER function
What is the Google Sheets Filter function?
In this example, we have a range of values in column A and we want to extract specific values from that range, for example the numbers that are greater than average, or only the even numbers.
The filter formula will return only the values that satisfy the conditions we set. It takes two arguments, firstly the full range of values we want to filter and secondly the conditions we're going to apply. The syntax is:
=FILTER("range of values", "condition 1", ["condition 2", ...])where Condition 2 onwards are all optional i.e. the Filter function only requires 1 condition to test but can accept more.
Read full article from Learn to use the powerful Google Sheets FILTER function
No comments:
Post a Comment