Count

G

gary

"Jones" is in B1 thru B10
"Peterson" is in B11 thru B15
"Frank" is in B16 thru B35
"Michael" is in B36 and B37
"Smith" is in B38 thru B62

Only at the LAST occurrence of each name, I want the
number of occurrences of that name displayed in column A.

For example, I want:
'10' displayed in A10
'5' displayed in A15
'20' displayed in A35
'2' displayed in A37
'25' displayed in A62

How can I do this?
 
D

Debra Dalgleish

Enter the following formula in cell A1, and copy down to the last row of
data:

=IF(B1=B2,"",COUNTIF(B$1:B1,B1))
 
A

Alan Beban

Enter in A1 and fill down to A62

=IF(COUNTIF($B$1:B1,B1)<COUNTIF($B:$B,B1),"",COUNTIF($B$1:B1,B1))

Alan Beban
 
Top