LibreOffice Calc: get the distinct/unique values in a column or a list of elements

These videos demonstrate how to get the distinct/unique values in a column or a list of elements in LibreOffice Calc.

Procedure to get the distinct values in a column or a list of elements:

Select the column (or the list of data) that you want to process
Click on the top menu Data
then click on the option group More Filters
and finally on the option Standard Filter...
In the new window, change the Field Name on the first row to - none -
Click on the Options label and enable the No duplications checkbox
Finally press the OK button

Video demonstrating how to get the distinct values in a column:

Video demonstrating how to get the distinct values in a list of elements:

LibreOffice Calc: Finding duplicate / common entries between two columns

This video demonstrates how to find all matching values between two columns in LibreOffice Calc. Precisely, in this video, we fill in columns A and B with random integer values between the numbers 1 and 100 (inclusive). The formula to generate the random values was the following: =RANDBETWEEN(1;100) After we…

4 January 2022

In "Office"

How to “group by” and sum or count in LibreOffice Calc (Excel)

In the world of spreadsheet applications, LibreOffice Calc stands out as a versatile and powerful tool for managing data. It offers a wide array of features that can help you organize, analyze, and make sense of your data. One of these features, often underutilized, is the Subtotals functionality. In this…

28 October 2023

In "Applications"

LibreOffice Calc: Get workbook filename only

Get workbook filename only For Linux and Mac =TRIM( RIGHT( SUBSTITUTE( LEFT( CELL("filename"), FIND("#", CELL("filename")) -2 ), "/", REPT(" ", LEN(CELL("filename"))) ), LEN(CELL("filename")) ) ) For Windows =TRIM( RIGHT( SUBSTITUTE( LEFT( CELL("filename"), FIND("#", CELL("filename")) -2 ), "\", REPT(" ", LEN(CELL("filename"))) ), LEN(CELL("filename")) ) ) The only change is changing the…

16 October 2018

In "Office"

This post is also available in: Greek