mode for text-strings ?

[alcorjr]

Hi everybody,

Is there a function that can return the most frequently appearing text string from a range?

Thanks.

 

[Ms996]

This formula

=INDEX(Rng,MATCH(MAX(COUNTIF(Rng,Rng)),COUNTIF(Rng,Rng),0))

array entered (That is, with Control Shift Enter, not just Enter), will return the (first) most common string in the range Rng

This formula works great.

How can I tweak to get the second highest, third highest? Need the top 5

 

[Fluff]

Is this for Excel or Google sheets?

 

[Ms996]

Not sure about the original poster, but I have used it on Google Sheets and it works. Should work on excel though as well

 

[Fluff]

In that case you need to start a new thread in the General Discussion & Other Applications section of the board, clearly stating that it's for Sheets.
You will also need to post a link to any other sites where you have asked this question, please see rule#13 about cross-posting. Message Board Rules