Home » Posts

Most frequent text with criteria

To find the most frequently occurring text in a range, based on the criteria you supply, you can use an array formula based on several Excel functions, including INDEX, MATCH, MODE, and IF. In the example shown, the formula in G5 is: =INDEX(supplier,MODE(IF(client=F5,MATCH(supplier,supplier,0)))) where "supplier" is the named range C5:C15, and "client" is the named range B5:B15. Note: this is an array formula and must be entered with control + shift + enter, except in Excel 365.

April 14, 2025 · 1 min · 48 words · Christopher Peterson

If the remainder is 0 (zero), we have an even row.

you might use INDEX to retrieve individual values, or entire rows and columns.

MATCH supports approximate and exact matching, andwildcards(* ?)

Formula for mode of text in every other row