Filter and Extract Data for Google Sheets

In contrast to Google Sheets filter, this add-on lets you set up all conditions within one plain window and preview the result while making quick adjustments at the same time.

Also, Filter and Extract Data won't mess with your source data. It will create another table wherever you choose.

As cheesy as it may sound, our add-on takes your experience with formulas to the next level. We use an advanced version of VLOOKUP — QUERY function. So no nested/array formulas or helper columns are needed anymore.

While standard Google Sheets VLOOKUP cannot look at its left, QUERY looks over the entire range at once: up, down, to the left, and to the right of the column(s) with your condition(s).

Unlike VLOOKUP and INDEX+MATCH which fetch only one record at a time, our Filter and Extract Data returns a range of all relevant values together. You can even decide to simply pull records from the source table or insert everything as a ready-made QUERY formula.

Run Filter and Extract Data from the Extensions tab and do the following:

1. Select the table you want to filter.
2. Decide upon the records you'd like to return.
3. Set the conditions.
4. Choose a place for the result.
5. Click Insert formula or Paste result.

See a more detailed description here.

Not at all :)

Just set the necessary conditions using 15 built-in comparison operators and let Filter and Extract Data do the rest.

Nope! Your skills and experience with formulas don't matter.

The options are designed in the most simple way: you tweak the conditions using common comparison operators such as equal to, is between, contains, etc., and Filter and Extract Data does the rest.

There are 15 different comparison operators to help you out.

Some will check if the value is equal to, less than, more than, or not equal to some numbers.

Others will get the info belonging to some period of time or number sets (is between).

You can also check all records for any part of specific chars, words, or numbers (contains / doesn't contain / starts with / ends with). Or go see if matches are blank or not or have errors in cells or not.