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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count the number of times a name occurs in a column 2
how to count maximum number of lines repeated for a site 4
Find MAX 4
Count function without double counting 1
Count the number of names in a column 9
return a list of names, from a large list of repeated names. 9
Count how many times a phrase comes up? 3
Function in Excel to count and list number of entries of text valuesin a row. 2

Top