Bug 161711 - Add COUNTUNIQUE function
Summary: Add COUNTUNIQUE function
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Calc-Function
  Show dependency tree / graph
 
Reported: 2024-06-20 09:29 UTC by Óvári
Modified: 2024-06-23 20:03 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Óvári 2024-06-20 09:29:21 UTC 
Description:
LibreOffice Calc 24.8 adds the UNIQUE function.

https://support.google.com/docs/answer/3093405

Steps to Reproduce:
https://support.google.com/docs/answer/3093405

Type in cell C1, =COUNTUNIQUE(A:A)

Actual Results:
#NAME?

Expected Results:
Works


Reproducible: Always


User Profile Reset: No

Additional Info:
Workaround

Type in cell C1, =COUNT(UNIQUE(A:A))
Comment 1 Roman Kuznetsov 2024-06-23 20:03:48 UTC 
I agree, set to NEW

There is no the COUNTUNIQUE function in Excel , btw