View original (French)

Text cell format formula

Solved
CATH -  
ccm81 Posted messages 11033 Status Membre -
Hello,

I would like to adapt the MODE formula (numerical) but for a series of text cells.
Example: runny creamy runny creamy creamy
How can I highlight creamy?

Thank you for your help

Configuration: Windows / Chrome 59.0.3071.86

2 réponses

Réponse 1 / 2
ccm81 Posted messages 11033 Status Membre 2 434
 
Hello

Your data in A2:A12 (without empty cells)
=INDEX(A2:A11,MODE(MATCH(A2:A11,A2:A11,0)))
Array formula to be confirmed with Ctrl+Shift+Enter (it will be enclosed in curly brackets)

Best regards
1
CATH
 
Perfect, thank you!!!!!!!!!!
0
Réponse 2 / 2
ccm81 Posted messages 11033 Status Membre 2 434
 
You're welcome

Have a nice end of the afternoon

Best regards
0