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 ↗
#data-cleaning
4 formula guides
Excel
=EXCEL(...)Excel Custom Sort by Color: Build a Priority Order
Sort Excel tables by cell color, font color, icons, or a custom list without separating rows from their records.
Explore ↗
Excel
=QUERY(...)Excel Power Query Unpivot Columns: Step-by-Step
Unpivot columns in Excel Power Query, preserve identifiers, clean blanks, and build refreshable analysis tables.
Explore ↗
Excel
=EXCEL(...)Excel Data Cleaning: Duplicates, Flash Fill, Text to Columns
Clean messy data in Excel. Master Remove Duplicates, Flash Fill, Text to Columns, TRIM, and Find & Replace for analysis-ready data.
Explore ↗