=INDEX(A10:A19,MAX((COUNTIF(A10:A19,A10:A19)=MAX(C OUNTIF(A10:A19,A10:A19)))*
ROW(INDIRECT("1:"&COUNTA(A10:A19)))))

Of course A10:A19 is my sample range...

<<< Note that this formula is an ARRAY formula
and MUST BE entered with Control+Shift+Enter
KeyBoard Combination

HTH

"Garry" wrote in message
om...
Hi,

I have a basic understanding of formulas and such, but I need to do
something and I am yet to find a solution. Its probably easy.

Say I have a list of names;
bob
bill
fred
fred
bob
fred
sandra
fred

I want to make a formula that will say 'fred', or the most common name
that appears.