Search code examples
google-sheets

How can I get a cell to return the most common value of 3 other cells that are all text based values, not numerical?

Cells A2, B2, & C2 all show answers to a specific question. I need E2 to produce the most common value from the results in A2:C2.

Eg. A2 contains "Orange," B2 contains "Purple," & C2 contains "Purple." So, the most common value is Purple. How do I get E2 to display "Purple?"

I have used MODE for this sort of thing in the past, but that only works for numerical values. Now I'm looking at text values and don't know how to find the most common value.

Solution

  • You may test this for three columns:

    =let(Σ,A2:C2, +filter(Σ,countif(Σ,Σ)>1))