count text values and return most common occurence
can it give me the most frequent value rather than me having to do three
separate counts, I actually want it to return the name of the text that
appears most.....
"Teethless mama" wrote:
=COUNTIF(A1:A100,"amber")
=COUNTIF(A1:A100,"red")
=COUNTIF(A1:A100,"green")
"MMcQ" wrote:
I have a column with the values red, amber and green.
I want to count the values and in the calculation field, show the value
which occurs most frequently.
e.g.
amber
amber
red
green
amber
the calcualtion field should return amber
|