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.
© 2023 Better Solutions Limited. All Rights Reserved. © 2023 Better Solutions Limited Top