Counting the instances of words

[DC_C2C]

I am looking for a formula that counts the instances of a word but then returns a value based on the greatest number of instances.

In Col A I have twelve rows, 4 of them have the word ‘Low’, 6 have the word ‘Medium’ and 2 have the word ‘High’

I would like the formula to look at Cells A1:A12 and return a value of Medium

If the data changes and there are 5 ‘Low’ 4 ‘Medium’ and 3 ’High’ the resulting formula would display ‘Low’

Thanks

 

[rakesh seebaruth]

=IF(COUNTIF(A1:A12,"Low")>COUNTIF(A1:A12,"Medium"), "Low", IF(COUNTIF(A1:A12,"Medium")>COUNTIF(A1:A12,"High"), "Medium", "High"))

 

[JEC]

=LET(r,A1:A12,TAKE(SORTBY(r,COUNTIF(r,r),-1),1))

 

[Fluff]

What should happen if two words score the same? For example Low & High both appear 5 times & Medium twice

 

[rakesh seebaruth]

In this case, the formula will return whichever value appears first in the IF statement it is checking. If you wish to have the formula return a different value in the case of a tie, you can modify the formula to check for equality between two values as well. So, if Low and High appear the same number of times, the formula could be changed to:

=IF(COUNTIF(A1:A12,"Low")>COUNTIF(A1:A12,"Medium"), "Low", IF(COUNTIF(A1:A12,"Medium")>COUNTIF(A1:A12,"High"), "Medium", IF(COUNTIF(A1:A12,"Low")=COUNTIF(A1:A12,"High"), "Tie", "High")))

 

[rakesh seebaruth]

In this case, if Low and High appear the same number of times, the formula will return "Tie".

 

[DC_C2C]

Thanks @rakesh seebaruth your formula sorted my issue.
Thanks to @JEC nice bit of innovation to my question - also worked
Thanks to @Fluff I did not think of that scenario