names in a long list

a1:a200 are a list of names. I need to determine which name is appearing
most often AND have the name populate B2 in the same worksheet. Would
appreciate any help you can offer.

Try this formula

=INDEX(A1:A200,MATCH(MAX(COUNTIF(A1:A200,A1:A200)),COUNTIF(A1:A200,A1:A200),0))

confirmed with CTRL+SHIFT+ENTER

=INDEX(A1:A20,MODE(MATCH(A1:A20,A1:A20,0)))

or

=INDEX(A1:A20,MATCH(MAX(COUNTIF(A1:A20,A1:A20)),COUNTIF(A1:A20,A1:A20),0))

both entered with ctrl + shift & enter, the first one is shorter but returns
error if there are blank cells within the range

adapt to fit your range

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"ferde" <ferde@discussions.microsoft.com> wrote in message
news:D4642C54-CBCD-4229-A9E1-624B0B6D8023@microsoft.com...
> a1:a200 are a list of names. I need to determine which name is
> appearing
> most often AND have the name populate B2 in the same worksheet. Would
> appreciate any help you can offer.

Thank you for your reply

"daddylonglegs" wrote:

>
> Try this formula
>
> =INDEX(A1:A200,MATCH(MAX(COUNTIF(A1:A200,A1:A200)),COUNTIF(A1:A200,A1:A200),0))
>
> confirmed with CTRL+SHIFT+ENTER
>
>
> --
> daddylonglegs
> ------------------------------------------------------------------------
> daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
> View this thread: http://www.excelforum.com/showthread...hreadid=521577
>
>

Thank you ,,,it works great

"Peo Sjoblom" wrote:

> =INDEX(A1:A20,MODE(MATCH(A1:A20,A1:A20,0)))
>
> or
>
> =INDEX(A1:A20,MATCH(MAX(COUNTIF(A1:A20,A1:A20)),COUNTIF(A1:A20,A1:A20),0))
>
> both entered with ctrl + shift & enter, the first one is shorter but returns
> error if there are blank cells within the range
>
> adapt to fit your range
>
> --
>
> Regards,
>
> Peo Sjoblom
>
> Northwest Excel Solutions
>
> www.nwexcelsolutions.com
>
> (remove ^^ from email address)
>
> Portland, Oregon
>
>
>
>
> "ferde" <ferde@discussions.microsoft.com> wrote in message
> news:D4642C54-CBCD-4229-A9E1-624B0B6D8023@microsoft.com...
> > a1:a200 are a list of names. I need to determine which name is
> > appearing
> > most often AND have the name populate B2 in the same worksheet. Would
> > appreciate any help you can offer.
>
>