Removing duplicates LIBREOFFICE CALC

LibreOffice Calc table processor allows you to delete table rows with repeating values in cells completely automatically. The function of removing duplicates in this program is not implemented in the most obvious way, but it is quite easy to understand it.

Next, let's see how to remove duplicate rows in LibreOffice Calc. Here are detailed instructions with explanations.

HOW TO REMOVE DUPLICATE ROWS IN LIBREOFFICE CALC

In LibreOffice Calc tables, duplicate rows are removed using filters. In this case, rows with duplicate values are deleted in their entirety, so this method is not suitable for selectively removing duplicate cells from a single column in a table with multiple columns.

SELECT RANGE

First, you need to designate the area in which duplicates will be removed. To remove repeats from an entire column, you must select the entire column:

The result will be as follows:

You can select a group of neighboring cells in the same column:

The result of removing repeats will be as follows:

SELECT FILTER

Filters in the LibreOffice Calc spreadsheet editor are located in the main top menu of the program under Data. To remove duplicate rows there, select Data, More Filters and Standard Filter:

CUSTOMIZE FILTER

The selected standard filter must be customized. First, in the appeared window of filter settings, you should click with the left mouse button on the small triangular icon of the drop-down list in the upper right corner under the word Value.

In the resulting drop-down list, you should select the topmost value Not empty with the left mouse button.

Then you should click with the left mouse button on the word Parameters in the lower left corner of the filter settings window.

After that, you should check the No repeats checkbox in the appeared additional settings.

This completes the filter settings.

REMOVE DUPLICATES

Now you should click with the left mouse button on the OK button in the lower right corner of the filter settings window.

After this click, all rows with duplicate cells in the previously selected range (the whole column or its selected part) will be deleted completely.

If something was deleted erroneously due to incorrect actions when using the filter, the filter action can be canceled using the standard method - by pressing Ctrl-Z or through the undo menu.

Now it is clear how to remove duplicates Libreoffice Calc. Removing duplicate rows works successfully, but it is not done in a very convenient way. We can only hope that in the next new versions of the program this function will be improved better.