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.