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.
- Find the mode for text values from a list/column with formula
- Find the mode for text values from a list /column with Kutools for Excel
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.
1. Select a blank cell where you will place the most frequent (mode for) text value, and click Kutools > Formula Helper > Lookup & Reference > Find the value that appears most often. 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.
You are guest
or post as a guest, but your post won't be published automatically.
To post as a guest, your comment is unpublished.· 2 years agothe names list in text format, text to column does not work. i tried bunch of stuff. please help.