How to find the mode for text value from a list/column in Excel?
As you know, we can apply the MODE function to quickly find out the most frequent number from a specified range in Excel. However, this MODE function does not work with text values. Please do not worry! This article will share two easy methods to find the mode for text values from a list or a column easily in Excel.
Recommended Productivity Tools for Excel
Office Tab: Bring powerful tabs to Office (include Excel), just like Chrome, Safari, Firefox and Internet Explorer. Save you half the time, and reduce thousands of mouse clicks for you. 30-day Unlimited Free Trial
Kutools for Excel: Save 71% of your time and solve 82% Excel problems for you. 300+ advanced tools designed for 1500+ work scenario, make Excel much easy and increase productivity immediately.60-day Unlimited Free Trial
This method will introduce an array formula to find the mode for text values in a list in Excel. Please do as follows:
Select a blank cell you will place the most frequent value into, type the formula =INDEX(A2:A20,MODE(MATCH(A2:A20,A2:A20,0))) (A2:A20 is the list where you will find out the most frequent (mode for) text value from) into it, and then press the Ctrl + Shift + Enter keys.
Now the most frequent (mode for) text value has been found and returned into the selected cell. See screenshot:
|Formula is too complicated to remember? Save the formula as an Auto Text entry for reusing with only one click in future!
Read more… Free trial
If you have Kutools for Excel installed, you can apply its Find most common value formula to quickly find out the most frequent (mode for) text values from a list without remembering any formulas in Excel.
Kutools for Excel - Combines more than 300 Advanced Functions and Tools for Microsoft Excel
1. Select a blank cell where you will place the most frequent (mode for) text value, and click Kutools > Formulas > Find most common value. See screenshot:
2. In the opening Formula Helper dialog box, please specify the list where you will look for the most frequent text value into the Range box, and click the Ok button.
And then the most frequent (mode for) text value has been found and returned into the selected cell.