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.

worksheet formula:-

=MODE("your range")

will give you what you want

-----Original Message-----
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.
.

Mode only works with Numbers.

You could get a unique list of entries using the Data=Filter=Advanced
filter dialog, select unique in the lower right corner.
Then you could put a countif formula by each and then sort the results

=Countif(A:A,B2)
Where B2 would hold one of the names.

--
Regards,
Tom Ogilvy

"TonyM" wrote in message
...

worksheet formula:-

=MODE("your range")

will give you what you want

-----Original Message-----
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.
.

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