Countif, Maxa or other function?

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

[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




"jacobk" <jacobk@discussions.microsoft.com> wrote in message
news:15151BA1-C06E-45A7-88C2-341480BD72F1@microsoft.com...
> 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.

[jacobk]

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)),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
>
>
>
>
> "jacobk" <jacobk@discussions.microsoft.com> wrote in message
> news:15151BA1-C06E-45A7-88C2-341480BD72F1@microsoft.com...
> > 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.
>
>