Google Sheets
=GOOGLE(...)Google Sheets UNIQUE Function: Extract Distinct Values
Remove duplicates and extract distinct values in Google Sheets with the UNIQUE function. Real examples, sorting, and error fixes.
Explore ↗
Google Sheets
19 formula guides
Google Sheets
=GOOGLE(...)Google Sheets COUNTUNIQUEIFS: Count Unique by Criteria
Count unique distinct values based on single or multiple conditions in Google Sheets using the native COUNTUNIQUEIFS function.
Explore ↗
Google Sheets
=GOOGLE(...)Google Sheets Import JSON API: Fetch Live Web Data
Fetch live REST API data into Google Sheets using custom Apps Script functions, JSON parsing, and scheduled refresh triggers.
Explore ↗
Google Sheets
=GOOGLE(...)Google Sheets INDIRECT: Build Dynamic Sheet References
Reference dynamic tab names, ranges, and multi-sheet summaries in Google Sheets using the powerful INDIRECT function.
Explore ↗
Google Sheets
=EDATE() / =TODAY()Google Sheets SEQUENCE: Generate Numbers, Dates & Grids
Generate dynamic number sequences, custom date ranges, and 2D matrix grids in Google Sheets using the SEQUENCE function.
Explore ↗
Google Sheets
=GOOGLE(...)Google Sheets TRANSPOSE: Flip Rows and Columns
Rotate tables, flip matrix dimensions, and combine TRANSPOSE with QUERY in Google Sheets for dynamic data reshaping.
Explore ↗
Google Sheets
=FILTER(...)Google Sheets FILTER with Optional Criteria: 3 Patterns
Build Google Sheets FILTER formulas with blank criteria, AND or OR logic, dropdowns, and no-match handling.
Explore ↗
Google Sheets
=IMPORT(...)Import Excel Tables into Google Sheets: What to Check
Import Excel tables and pivot tables into Google Sheets, then verify relationships, formulas, and converted data.
Explore ↗
Google Sheets
=EDATE() / =TODAY()Google Sheets Date Functions: DATEDIF, EDATE & EOMONTH
Use Google Sheets date functions for age, deadlines, month ends, and business-day calculations across locales.
Explore ↗
Google Sheets
=GOOGLE(...)Google Sheets SHEET & SHEETS Functions: Reference Tabs
Use SHEET and SHEETS in Google Sheets to get tab numbers and count sheets. New 2026 functions explained.
Explore ↗
Google Sheets
=FILTER(...)How to Sum Filtered Rows with Custom Criteria in Google Sheets
Learn two ways to sum visible filtered rows in Google Sheets while excluding rows that match custom criteria.
Explore ↗
Google Sheets
=GOOGLE(...)Google Sheets ARRAYFORMULA: Complete Guide with Examples
Master ARRAYFORMULA in Google Sheets. Combine with FILTER, SPLIT, IF across columns — avoid common mistakes.
Explore ↗
Copilot AI
=GOOGLE(...)Google Sheets Canvas: Create Interactive Dashboards with AI
Create interactive dashboards in Google Sheets with Canvas. Build kanban boards, heat maps, and data views without code.
Explore ↗
Google Sheets
=GOOGLE(...)Google Sheets AI Function: How to Use =AI() in Your Spreadsheets
Use the Google Sheets AI function =AI() for text, summarization, sentiment, categorization via natural language.
Explore ↗
Google Sheets
=FILTER(...)FILTER Function in Google Sheets: Complete Guide
Learn FILTER function in Google Sheets. Extract data matching your conditions with simple step-by-step examples.
Explore ↗
Google Sheets
=EDATE() / =TODAY()Google Sheets 2026: New Functions and Features Update
Google added new functions and AI features to Sheets in 2026. See what changed, from new formulas to Gemini integration.
Explore ↗
Google Sheets
=GOOGLE(...)Google Sheets IMPORT Functions: IMPORTRANGE, IMPORTHTML, IMPORTXML
Learn Google Sheets IMPORT functions. IMPORTRANGE, IMPORTHTML, IMPORTXML, and IMPORTDATA for external data.
Explore ↗
Google Sheets
=QUERY(...)Google Sheets QUERY Function: Complete Guide for Excel Users
Learn Google Sheets QUERY with SQL syntax. Guide for Excel users switching to Sheets — SELECT, WHERE, GROUP BY.
Explore ↗
Google Sheets
=SPLIT,(...)SPLIT, TEXT, and Text Functions in Google Sheets
Learn SPLIT and text functions in Google Sheets. Split text, extract characters, and format data with examples.
Explore ↗