Filter(across multiple sheets) tutorial

Use the FILTER(Across multiple sheets) formula to adapt the FILTER function across multiple datasets, on different sheets and tables.

filter(contains) Function Tutorial

Use the FILTER(Contains) function to filter large datasets with a condition that the data contains a partial match of the lookup value.

=filter, Filter(and) , filter(or) Tutorial

Learn the basics of the FILTER function, as well as some intermediate and advanced techniques. Including: FILTER(And), FILTER(Or), FILTER(Contains)

Filter(does not contain) Tutorial

Use the FILTER(Does not Contain) function to filter large datasets with a condition that the data does not contain any part of the lookup value.

Filter(columns) function Tutorial

A typical FILTER function works by filtering a vertical table of data. Use this FILTER(Columns) formula to filter the columns/fields.

Filter(top 10), filter(Top N) Tutorial

Easily filter a table of data so only the TOP10 results are displayed. This can be updated to any number of results that you desire. Use this FILTER(Top10) formula.

eXCEL DATA UNTELLIGENCE

FILTER FUNCTION TUTORIALS