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 ↗
#unique
2 formula guides
Excel
=FILTER(...)Dynamic Array Functions in Excel: FILTER, SORT, UNIQUE, SEQUENCE
Master FILTER, SORT, UNIQUE & SEQUENCE in Excel. Build reports that auto-update with spill ranges — no VBA required.
Explore ↗