You can use MODE for this.

=MODE(A1:A5)

Or try this for extra features!

="The most common occurence is: "&MODE(A1:A5)&" and it's used
"&COUNTIF(A1:A5)&" times"

Colin


--
Colin Vicary
------------------------------------------------------------------------
Colin Vicary's Profile: http://www.excelforum.com/member.php...o&userid=10472
View this thread: http://www.excelforum.com/showthread...hreadid=488194