Apr 12, 2018

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})