[Libreoffice-bugs] [Bug 144017] New: New Function to count duplicates in list

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=144017

            Bug ID: 144017
           Summary: New Function to count duplicates in list
           Product: LibreOffice
           Version: unspecified
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: enhancement
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: Bug2020 at JohnMurrell.org.uk

Description:
Calc has a function to apply conditional formatting to duplicate values in a
list but this only provides visual information though when the 3 bugs are 
cleared it should be possible to filter on the duplicate values.

My suggestion is for a new function that compares a value in a cell with the
values in a list and returns the number of duplicates. Zero being returned if
the value does not exist in the list otherwise the number of occurrences. The
cell to be compared can either be in the list in which case it will provide the
number of times a value is duplicated or else external to the list where it
provides the number of matches. 

To make the function more useful it could have a flag which either reports all
the matches or only the first duplicate. In the first mode it would be useful
to carry out other operations on the duplicate cells and in the second to count
the total number of duplicates.

Suggested name for function is something like COUNTMATCH(comparison cell, list,
mode) as it is an expanded version of Match with different functionality.

Steps to Reproduce:
1. Enhancement as above
2.
3.

Actual Results:
NA

Expected Results:
NA


Reproducible: Always


User Profile Reset: No


OpenGL enabled: Yes

Additional Info:
There are some work arounds such as using pivot tables to count the number of
duplicate values and sorting the pivot table by the number of duplicates but
this is difficult to use partly because of the need to refresh the pivot table
if the data changes and also the difficulty of retrieving an unknown number of
results from a pivot table. The pivot table method also does not work if the
cell to be matched is outside the pivot table source array.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210823/2cb15bf6/attachment.htm>