[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

--- Comment #3 from Eike Rathke <erack at redhat.com> ---
(In reply to John Murrell from comment #2)
> 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.
RAND() and RANDBETWEEN() generate new random numbers on each cell input and
whenever any recalculation occurs. You could use RAND.NV() or RANDBETWEEN.NV()
for non-volatile random numbers.

-- 
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/20210827/8074f283/attachment.htm>