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)),CO UNTIF(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" wrote in message
...
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.