need to find a max count without knowing what I'm counting (list of names)

K

KR

I have a list of thousands of names, and I need to check and find out the
maximum number of times any name is repeated (I don't care what the name is,
just need to know the maximum number).

Does anyone have a quick and dirty formula (or array formula) that would
tell me the largest number of repeats?

Thanks!
Keith
 
R

Richard Neville

Not exactly quick and dirty, but this should work: copy the spreadsheet
within your Excel document. Sort by name, which will return an alphabetical
listing. Using the Subtotals function (at each change in name), generate a
count by name. If you just need to know the name with the maximum count, you
can scroll through the sheet to find this, or use the MAX function for the
column containing the counts.
 
B

Bob Phillips

=COUNTIF(A:A,"the_name")

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top