How to Filter Using Custom Formula in Google Sheets

To filter data using a custom formula in Google Sheets, you can use the FILTER function. The FILTER function allows you to filter a range of data based on specific criteria that you define.

Here's how to use the FILTER function with a custom formula in Google Sheets:

1. Open your Google Sheet containing the data you want to filter.
2. Click on an empty cell where you want to display the filtered data.
3. Enter the FILTER function in the following format:

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

where range is the data you want to filter, and condition1, condition2, etc. are the conditions you want to apply to filter the data. You can use custom formulas as conditions to filter the data.

Example

Let's say you have a dataset of products with their prices and quantities, and you want to filter the products with a price greater than $50 and a quantity less than 100.

Here is a sample dataset:

A           B        C
-----------------------
Product     Price     Quantity
Product 1   30        200
Product 2   60        50
Product 3   80        120
Product 4   40        80
Product 5   70        20

To filter the dataset, follow these steps:

1. Click on an empty cell where you want to display the filtered data, for example, cell E1.
2. Enter the FILTER function with custom formulas as conditions:

=FILTER(A2:C6, B2:B6 > 50, C2:C6 < 100)

This formula filters the data in the range A2:C6 with the conditions that the price (column B) is greater than 50 and the quantity (column C) is less than 100.

3. Press Enter to display the filtered data:

E          F        G
----------------------
Product 2  60        50
Product 5  70        20

Now, you have successfully filtered the data using a custom formula in Google Sheets.