How to Remove Duplicate Rows in Google Docs

If you're an avid fan of Google Docs and use its spreadsheet regularly here's a tip that might come in handy.

Ever wished you'd be able to remove duplicate rows of info? For instance, imagine you have a long list of emails, but there might be duplicate entries and you need to get a list without any duplicates.

Instead of trying to do it manually and waste a lot of time, you can simply use the UNIQUE function.
Just place your cursor in an empty cell and enter:

=UNIQUE(...) 

and select the area with the duplicate rows to process. And that's it!

Hope you'll find it useful.