"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
CountStringCombi - Counts how often a string is followed by another string in a given range (or array).