https://bugs.documentfoundation.org/show_bug.cgi?id=144017
Mike Kaganski <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Keywords| |needsUXEval --- Comment #1 from Mike Kaganski <[email protected]> --- 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.
