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@lists.freedesktop.org Reporter: bug2...@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.