Forum Discussion
MODE OF ALPHANUMERIC CHARACTERS
To Everyone, I know how to find the commonest number in a set of entries that are all numbers, i.e. the MODE function. However, I am not sure how to find the commonest letter if the entries are a...
SMarganHi,
You can use MATCH and count (mode) the numeric matches of the words/letters.
Combine with INDEX to get the words.
=LET(
data; FILTER(A:A;A:A<>"");
numericMatches; MODE.MULT(XMATCH(data;data));
output; INDEX(data;numericMatches);
output
)
A nice piece of lateral thinking using XMATCH to turn alphanumeric strings to unique numbers.