What if the data contains more than one value occurring the most? For
example, if the data contains the following...

amber
amber
red
red
green
blue
yellow
yellow
brown

....what result do you expect?

In article ,
MMcQ wrote:

I have a column with the values red, amber and green, in text format, not
just a colour in the cell.
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