"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 sbSfreq  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
sbUniq  A function which is missing in Excel ©: Return unique input values sbUniqRank  If you need a unique rank, even if inputs occur more than once
Excursus:
CountStringCombi  Counts how often a string is followed by another string in a given range (or array).
