Filter

6 lessons in order

Learn how to fix the FILTER function not working in Google Sheets, including #N/A errors, wrong results, and range mismatch issues.

Learn how to filter duplicates in Google Sheets using FILTER with COUNTIF, UNIQUE, conditional formatting, or Google Apps Script.

Learn how to filter with multiple conditions in Google Sheets using FILTER and QUERY functions, combining AND, OR, text, and numeric logic.

Learn how to use the FILTER function with the OR condition in Google Sheets to filter data across columns and handle multiple criteria easily.

Filter unique values in Google Sheets using the UNIQUE function, filters, or conditions to extract distinct product, city, or customer data.

Learn how to filter Google Sheets without affecting others, using filter views and alternatives to manage data efficiently.