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.
How To Use in Sheets
Google Sheets - Remove Duplicate Data with the UNIQUE Function
Duplicate data can be a chore to find and remove in a spreadsheet. The UNIQUE function does it quickly and easily.
4Better Sheets Tutorials