Combine FILTER and MONTH in Google Sheets to return every row from a chosen month, with a worked example, month-and-year filtering, monthly totals and fixes for common errors.
Tag: Spreadsheet Tips
DGET Function in Google Sheets: A Practical Example
Learn how the DGET function in Google Sheets returns one value that meets several conditions, with a worked Name and Month example, four variations and fixes for #VALUE! and #NUM!.
FILTER and ISBLANK Function in Google Sheets (With Example)
Use FILTER with NOT(ISBLANK()) in Google Sheets to return only the rows that have a value, with a worked example, five variations, common errors and a free practice file.
INDEX with Double MATCH in Google Sheets (Two-Way Lookup)
Use INDEX with two MATCH functions in Google Sheets to look up any employee by ID and any field by its header, with a worked call-centre example and a free practice file.
Magic Search Box in Google Sheets (FILTER Formula)
Build a magic search box in Google Sheets with one FILTER formula: choose a field, type a keyword and see matching rows with live totals. Includes syntax, a worked example and variations.