Return the most frequently occurring word

{=INDEX(cellrange, MODE( MATCH(cellrange, cellrange,0)))}



Built-in Functions

MODE - (MODE.SNGL) The value that occurs most frequently in a list or array of numbers.
INDEX - The value from a cell range which is the intersection of a row AND a column.
MATCH - The position of a value in a list, table or cell range.


© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited Top