[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

Mike Kaganski <mikekaganski at hotmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Keywords|                            |needsUXEval

--- Comment #1 from Mike Kaganski <mikekaganski at hotmail.com> ---
This is completely useless IMO. There are infinite possible things that one may
think would be nice to have a dedicated function, but when there are already
functions that allow one to have the data, it would only create clutter and
increase learning curve, not improve experience in any way.

To know how many duplicates are there in a list for a cell in a list:

  =COUNTIFS(A1:A1000;A1)

To know how many duplicates are there in a list for a value not necessary in
the list:

  =COUNTIFS(A1:A1000;B1)
  =COUNTIFS(A1:A1000;23)

To know if this is the first duplicate of this value:

  =AND(COUNTIFS($A2:$A$1000;A1)>0;COUNTIFS($A$1:$A1;A1)=1)

... and so on. Creating own formulas for complex result is the power that
spreadsheets give you, and trying to invent a dedicated function for each such
case is counter-productive.

WONTFIX IMO.

-- 
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/4fbd9f35/attachment.htm>