Return the most frequently occurring word

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



Built-in Functions

MODE - (MODE.SNGL) The first number that appears the most often in a set.
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.


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