<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><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">144017</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>New Function to count duplicates in list
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>unspecified
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>enhancement
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>Bug2020@JohnMurrell.org.uk
</td>
</tr></table>
<p>
<div>
<pre>Description:
Calc has a function to apply conditional formatting to duplicate values in a
list but this only provides visual information though when the 3 bugs are
cleared it should be possible to filter on the duplicate values.
My suggestion is for a new function that compares a value in a cell with the
values in a list and returns the number of duplicates. Zero being returned if
the value does not exist in the list otherwise the number of occurrences. The
cell to be compared can either be in the list in which case it will provide the
number of times a value is duplicated or else external to the list where it
provides the number of matches.
To make the function more useful it could have a flag which either reports all
the matches or only the first duplicate. In the first mode it would be useful
to carry out other operations on the duplicate cells and in the second to count
the total number of duplicates.
Suggested name for function is something like COUNTMATCH(comparison cell, list,
mode) as it is an expanded version of Match with different functionality.
Steps to Reproduce:
1. Enhancement as above
2.
3.
Actual Results:
NA
Expected Results:
NA
Reproducible: Always
User Profile Reset: No
OpenGL enabled: Yes
Additional Info:
There are some work arounds such as using pivot tables to count the number of
duplicate values and sorting the pivot table by the number of duplicates but
this is difficult to use partly because of the need to refresh the pivot table
if the data changes and also the difficulty of retrieving an unknown number of
results from a pivot table. The pivot table method also does not work if the
cell to be matched is outside the pivot table source array.</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>