Counting items

  • Thread starter Thread starter Garry
  • Start date Start date
G

Garry

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.
 
=INDEX(A10:A19,MAX((COUNTIF(A10:A19,A10:A19)=MAX(COUNTIF(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
 
Back
Top