<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:mikekaganski@hotmail.com" title="Mike Kaganski <mikekaganski@hotmail.com>"> <span class="fn">Mike Kaganski</span></a>
</span> changed
<a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - New Function to count duplicates in list"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=144017">bug 144017</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">Keywords</td>
<td>
</td>
<td>needsUXEval
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - New Function to count duplicates in list"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=144017#c1">Comment # 1</a>
on <a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - New Function to count duplicates in list"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=144017">bug 144017</a>
from <span class="vcard"><a class="email" href="mailto:mikekaganski@hotmail.com" title="Mike Kaganski <mikekaganski@hotmail.com>"> <span class="fn">Mike Kaganski</span></a>
</span></b>
<pre>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.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>