Countif, Maxa or other function?

J

jacobk

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.
 
P

Peo Sjoblom

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)),COUNTIF(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
 
J

jacobk

Peo,

This was what I looked for!!!

Thanks for you great help!

Greetings,

JacobK.
 
Top