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
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