I am a supporter of St. Joseph's hospice. If you find this site useful or if it helped you, consider a small donation to St. Joseph's, please.

Information on
St. Joseph's

Donation Link

"It's not what you look at that matters, it's what you see." [Henry David Thoreau]

If you like to create a statistic about frequencies of strings or numbers, you can use pivot tables. For smaller and less complex statistics SUMPRODUCT or even COUNTIF might suffice. Please see here for a worksheet function solution to create a list of unique identifiers and their frequency.

I think that SUMPRODUCT needs quite a long runtime and too much effort to maintain statistics on larger lists. Pivot tables are sometimes too complex for the casual user - and they do not automatically update with a recalculation.

So there is a gap between these two approaches which I think I can fill. I offer several versions of macros to count frequencies or to add or concatenate entries or to identify max or min for given combinations:

Pstat - Apply a function like MIN/MAX/SUM on given strings/numbers combinations with conditions applied

Cfreq - Concatenates entries (comma separated) for given string/number combinations
Mfreq - Apply a function like MIN/MAX/SUM on given strings/numbers combinations
Pfreq - List frequencies for given string/number combinations
Sfreq - Sum values for given string/number combinations

Older versions which operate on simple names or strings:

Afreq - Add numbers given for several (repeating) names.
Lfreq - List frequencies for given strings or numbers

Excursus:

CountStringCombi - Counts how often a string is followed by another string in a given range (or array).