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

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:

1. Select the column (or the list of data) that you want to process
2. Click on the top menu Data
   then click on the option group More Filters
   and finally on the option Standard Filter...
3. In the new window, change the Field Name on the first row to - none -
4. Click on the Options label and enable the No duplications checkbox
5. 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 Ιανουαρίου 2022

σε "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 Οκτωβρίου 2023

σε "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 Οκτωβρίου 2018

σε "Office"

This post is also available in: Αγγλικα