If so, try this function;
This will count the number of times Fred, (or fred), appears in columns A and B, from rows 1 to 39.
It displays the number of times the word appears.
I have a sheet containing 30 columns of identifiers (lets call them names). I want to have frequency of every name appearing in the columns, All columns are of different lengths.
In other words, is it possible to compare all these 30 columns at once and get an output as name of identifier and its frequency?