software

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.

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 amp; enter

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

quot;jacobkquot; gt; wrote in message
...
gt; Hi all,
gt;
gt; I'm having a column with text items.
gt; I'm looking for a function which shows the text value that is most
gt; represented in the specific colomn.
gt;
gt; Can anyone help?
gt;
gt; Thanks, JacobK.Peo,

This was what I looked for!!!

Thanks for you great help!

Greetings,

JacobK.

quot;Peo Sjoblomquot; wrote:

gt; If there are no blank cells in the range
gt;
gt; =INDEX(A2:A50,MODE(MATCH(A2:A50,A2:A50,0)))
gt;
gt; if there can be blanks
gt;
gt; =INDEX(A2:A50,MATCH(MAX(COUNTIF(A2:A50,A2:A50)),CO UNTIF(A2:A50,A2:A50),0))
gt;
gt; both entered with ctrl shift amp; enter
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; Northwest Excel Solutions
gt;
gt; www.nwexcelsolutions.com
gt;
gt; (remove ^^ from email address)
gt;
gt; Portland, Oregon
gt;
gt;
gt;
gt;
gt; quot;jacobkquot; gt; wrote in message
gt; ...
gt; gt; Hi all,
gt; gt;
gt; gt; I'm having a column with text items.
gt; gt; I'm looking for a function which shows the text value that is most
gt; gt; represented in the specific colomn.
gt; gt;
gt; gt; Can anyone help?
gt; gt;
gt; gt; Thanks, JacobK.
gt;
gt;