Is there a unique function in LO Excel

English
, ,
#1

What Is the unique function in LO Excel

1 Like
#2

LO Excel

There is no LibreOffice Excel

#3

LO Excel equivalent…CALC !

#6

I need this .

#4

Hello,

the bad news: LibreOffice Calc does not have a UNIQUE() function. There is an enhancement request tdf#126573 Add array functions in Calc: FILTER, SORT, SORTBY, UNIQUE, SEQUENCE, RANDARRAY to implement such functions.

Hope that answers your question.

#5

You can create your own macro functions, like this MYUNIQUE function in my sample file. Use it as an Array Function of the LibreOffice Calc application.

MyUnique.ods

1 Like
Bestaat de functie UNIQUE in calc?
Dropdown list (strange case for me)
LO Calc restricts the size of an array function output based on the initial results
#7
  1. A pivot table with a set of row fields displays the set of unique items.
  2. The standard filter has options to filter unique items in place or copy them to some other place
  3. LibreOffice has a database component where this is the most trivial functionality.

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.