Countif, Maxa or other function?
 

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.

Countif, Maxa or other function?
 

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.

Countif, Maxa or other function?
 

Peo,

This was what I looked for!!!

Thanks for you great help!

Greetings,

JacobK.

"Peo Sjoblom" wrote:

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.