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

[bugzilla-daemon at bugs.documentfoundation.org]

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

John Murrell <Bug2020 at JohnMurrell.org.uk> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|---                         |INVALID
             Status|UNCONFIRMED                 |RESOLVED

--- Comment #2 from John Murrell <Bug2020 at JohnMurrell.org.uk> ---
Ok,

The function COUNTIFS does something similar to what I was proposing. So I will
close this.

However COUNTIFS does not actually work in my application, I think because the
list of random numbers re-calculates each time COUNTIFS runs so the results
keep on changing. As a result when you filter on the COUNTIFS >1 you it does
not show the duplicates and takes about 1/2 hour to run. Not sure if this is a
bug or expected behaviour but the only way it appears to get the duplicated
results is to use a pivot table or do a filter on the cell colours when the
filtering on conditional results bug is fixed.

-- 
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/20210826/b4c57e36/attachment.htm>