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...
With 365
= LET(
distinct, SORT(UNIQUE(alphanum)),
freq, COUNTIFS(alphanum,distinct),
FILTER(distinct, freq=MAX(freq)))
Thank you, though I have to pass the glory to https://www.excel-easy.com/examples/mode.html 🙂
Your solution favours combining fewer functions into new applications - a method I generally prefer.
Your solution favours combining fewer functions into new applications - a method I generally prefer.