Filter Unique Records in Google Docs
If you like to find out unique records from a table in Google Sheets, use the UNIQUE formula as shown in this screencast. You can use it on a single column or on multiple columns of data. In the example below the formula returns rows that are unique and does not repeat the duplicate rows abc & ddd.
Click an empty cell, type =UNIQUE(, select the range of cells you want to filter and then close the parenthesis.
This function will come in handy if you are trying to generate a unique list of Names or Email addresses to avoid any duplicates.