Syntax:
LISTCOUNT( data:Range or Array )
Returns a two-column array with the first column being a sorted list of unique entries from the first column of the data range of cells (or array), and the second column giving the number of occurrences of each entry.
If data has two columns the second column will be treated as a corresponding set of numbers to be added for each entry, rather than simply counting the number of occcurences of each entry.
Example:
You have a list of customer names in column A
and in column C
you have a list of sales figures for individual sales to those customers, then
SET_VALUE(D1:E20, LISTCOUNT({A1:A100, C1:C100}))
would write out 20 rows of customers names and total sales figures in D1:E20
.
{A1:A100,C1:C100}
makes a two column array of 100 rows.
You could use SORT() and FLIP() to sort the result of LISTCOUNT() into order before listing it out.