=INDEX(J1:J20,MATCH(MAX(COUNTIF(J1:J20,J1:J20)),CO UNTIF(J1:J20,J1:J20),0))

This is an array formula that must be inserted with CNTRL-SHFT-ENTER rather
than just ENTER. Adjust the range to suit your needs.
--
Gary''s Student - gsnu200795


"matt3542" wrote:

Hi there,

I am trying to determine the most frequently occurring (mode) text entry but
my understanding is that the mode function is only used for numeric data? I
have a large dataset which lists sickness reasons and I would like to find
out the mode and return the text value to cell J163. In the example below the
mode would be "vomiting", please can anyone help, would be most appreciated,
thanks Matt

e.g

Col J

Vomiting
Vomiting
Flu symptoms
Flu symptoms
Flu
Stomach upset
Withheld
Vomiting
Sickness
vomiting