If there are no blank cells in the range

=INDEX(A2:A50,MODE(MATCH(A2:A50,A2:A50,0)))

if there can be blanks

=INDEX(A2:A50,MATCH(MAX(COUNTIF(A2:A50,A2:A50)),CO UNTIF(A2:A50,A2:A50),0))

both entered with ctrl + shift & enter

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"jacobk" wrote in message
...
Hi all,

I'm having a column with text items.
I'm looking for a function which shows the text value that is most
represented in the specific colomn.

Can anyone help?

Thanks, JacobK.