Count

  • Thread starter Thread starter gary
  • Start date Start date
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?
 
Enter the following formula in cell A1, and copy down to the last row of
data:

=IF(B1=B2,"",COUNTIF(B$1:B1,B1))
 
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
 
Back
Top