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

JustGiving - Sponsor me now!



"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:

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

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).

Sulprobil   Get it done   Contact   Disclaimer   Impressum   Download