View original (French)

Text cell format formula

Solved
CATH -  
ccm81 Posted messages 11033 Status Member -
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 answers

  1.
    ccm81 Posted messages 11033 Status Member 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
    1. CATH
       
      Perfect, thank you!!!!!!!!!!
      0
  2. ccm81 Posted messages 11033 Status Member 2 434
     
    You're welcome

    Have a nice end of the afternoon

    Best regards
    0