Unique rows in Google spreadsheets

UNIQUE
Returns unique rows in the provided source range, discarding duplicates. Rows are returned in the order in which they first appear in the source range.

Sample Usage
UNIQUE(A2:B26)

UNIQUE({1, 2; 3, 4; 5, 6})

Featured Post

Are you self-employed and wondering how you could make your day-to-day accounting tasks easier?

$50 for every new paid QuickBooks Self-Employed subscription referred https://quickbooks.grsm.io/petercruz