How to Remove Duplicates Without Any Plugin on Google Doc Spreadsheet
Duplicate contens can be appeared on your data due to typo graphical errors, careless entry or while applying copy and paste. Whatever the reason, you can easily find it on Google Doc Spreadsheet. Google recently introduced add-ons to its cloud powered office application. By virtue of this addition Google Doc Spreadsheet is now more powerful. One of the useful add-on I found on Google Doc Spreadsheet is Remove Duplicates. It is easy to use and more advanced in finding and removing duplicates. But the changes can’t be reversed! But without this add-on you can remove duplicates. We can use the unique() function in google doc spreadsheet to remove duplicate contents. Unique() is one of the ‘unique‘ Google Doc Spreadsheet function that not available in Microsoft Excel in the same name. But you can use Excel Advanced Filter option to find and get unique contents.
Here we can see how to use unique() function in Google Doc Spreadsheet to remove duplicate contents. See the list of some of my favorite books and authors. I intentionally doubled Agatha Christie’s “A Pocket Full of Rye” twice. So let us see how we can remove the duplicate content with ease.
Now in another cell I’ve applied the unique() Google Doc Spreadsheet function as below.
It will copy the content to where the formula applied. It’s very easy to use the unique function. Just type “unique(” and electe the enitre data and close the bracket. Press enter key to see the result! Delete the first data as you have already got the data without duplicates. Thus you can use the unique() function to remove duplicate data.
Things to remember!
The unique content will cheque the data range for duplicates. For example in the above, the dupliates contents are in first and last row. For example, if the “Year Published” is different in both rows, the above function will considered both as separate entry, not unique.
If you want to colour the duplicates, or remove premanently from the existing data itself, use the add-on “Remove Duplicates” from the add-on menu. Hope you enjoyed this Google Doc Spreadsheet tips.
About Article Author
In this tutorial I will explain you how to use Data Validation on Google Doc Spreadsheet. It is important to
When you have a long range of data arranged in row wise and want to change it into column wise,
We have a separate section on Info Inspired completely dedicated to Google Doc Spreadsheet Tutorials. In this post we can
Earlier we have posted a complete tutorial about creating line chart in Google Doc Spreadsheet. Now in this post we
Learn how to create a chart in Google Doc Spreadsheet. It’s so simple that any one without any prior knowledge
A pro MS Excel user may find some difficulty in getting familiar with Google Spreadsheet. There are plenty of shortcut