Count the number of times a name occurs in a column

[Gary]

Hi All,

I have a data in thousands of rows......and one name is repeated several
times..now I want to count the number of times a name appears and also I
need to find the top three name that occur maximum number of times.

Please Help
Thanks

 

[CLR]

Check out the Data > Subtotals......follow the menus.......should be of some
help

hth
Vaya con Dios,
Chuck, CABGx3

 

[Peo Sjoblom]

=COUNTIF(A2:A5000,"Name")

or

=COUNTIF(A2:A5000,"*Name*")

if there are other text in the same cells

I would extract all unique names first by selecting the names,
do data>filter>advanced filter, select copy to another location
and unique records

then if you extracted the names to H2:H50, in an adjacent cell lik
I2 put

=COUNTIF($A$2:$A$5000,H2)


copy down to I50, then
sort on the help column descending, the top 3 would be the first 3

OR use a pivot table, select the data, do data>pivot table and pivot
chart report, click next and select layout, drag the names header to the
data and the row, then click finish, then right click in the pivot
table, select field settings and advanced, select top 10 autoshow,
change it to top 3 and click OK twice



Regards,

Peo Sjoblom