=INDEX(rng,MATCH(MAX(COUNTIF(rng,rng)),COUNTIF(rng ,rng),0))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"meegan" wrote in message
...
I have a column of data and i would like to know what number occur the
most
frequently. I dont know how to accomplish this though...could anyone
please
help me? Thank you if you can!