Excel Formulas to Find the Most Frequent Text with Criteria!!

Assume that you have a list of values, and you have to find out the most frequent text on it with certain criteria. How can you calculate them quickly? Today I introduce you to some formulas to solve this problem. Let’s see them below!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

General Formula:

You can use the below formula to find out the most frequently used text with certain criteria in Excel.

{=INDEX(range1,MODE(IF(range2=criteria,MATCH(range1,range2,0))))}

Syntax Explanations:

INDEX – The INDEX function returns the value at a given position in a range or array
MODE – This function returns the most frequently occurring value from a range of data. Read more on the MODE function.
IF – In Excel, the IF function returns one value for a TRUE result and another for a FALSE result.
MATCH – This function helps to locate the position of a lookup value in a row, column, or table. Read more on the MATCH function.
Range – It represents the input value.
Comma symbol (,) – It is a separator that helps to separate a list of values.
Parenthesis () – The main purpose of this symbol is to group the elements.

Practical Example:

Refer to the below example image.

Here, we will enter the input values in Column B and Column C.
Now we need to find out the most frequently used text based on certain criteria.

Select any cell and type the above-given formula.

Finally, Press CTRL + SHIFT + ENTER keys to get the result.

Wrap-Up:

From this tutorial, you can get some clarification on how to find out the most frequent text with certain criteria in Excel. Hope you like it. Leave a comment or reply below to let me know what you think!

Thank you so much for visiting *Geek Excel!! **If you want to learn more helpful formulas, check out Excel Formulas *!! **