Remove duplicate entries from a column in libreoffice.

Very often while dealing with data in Excel files, we might have rows of data that might have got repeated several times. If we want to remove these duplicate rows we can follow the following steps.

Let us say we have the following excel file 

We can see that the row of names has the same name repeated more than once. If we want to view only those rows which are unique then first select the column from which the duplicate entries have to be removed from

Now click data->More filters->standard filter 

In this make sure none of the columns is chosen in the filed name options, now click on the small triangle labelled options at the left hand side to open more options.

From this tick the option "No duplications" Click OK. 

Now we should see that only the unique rows would be listed .