Forum Discussion

Jeff_Ho's avatar
Jeff_Ho
Copper Contributor
Dec 09, 2020

Determine most common text in an incomplete list

Hi All,   I am looking to determine the most common occurrence of a text entry in a list. I am using the following formula: {=INDEX(E4:E11,MODE(IF(E4:E11 <> 0,MATCH(E4:E11,E4:E11,0))))}   The fo...
excel
Formulas and Functions
JMB17's avatar
JMB17
Bronze Contributor
Dec 10, 2020

Jeff_Ho 

 

I believe you could use the frequency function (see attached). You may be able to shorten the formula some if you have the LET function as some parts are redundant.

 

I'm assuming total length will be zero if level of detail is zero, so I didn't include a test/condition for that.

Jeff_Ho's avatar
Jeff_Ho
Copper Contributor
Dec 10, 2020

Thanks JMB17 

 

Your solution works perfectly, thanks for taking the time to solve this one for me, it is much appreciated.

  • JMB17's avatar
    JMB17
    Bronze Contributor
    Dec 10, 2020
    I'm glad to hear that worked for you.

Resources