Excel: Count function

[tired]

Hi Team -

I have a sheet w/ near 1,000 rows containing last names. After sorting is there a function to count how many times a last name appears in the sheet???


Thanks in advance

 

[Dan Waterloo]

Use a pivot table.

 

[Lewiy]

Try using COUNTIF():

Book1
	A	B	C	D
1	Jones	3
2	Jones
3	Jones
4	Smith
5	Smith
6	Wood
7	Wood
8	Wood
9	Wood
10
11
12
Sheet2