CODEWITHSUNDEEP
excel
Ron L
Ron L

Reputation: 51

Count repetitive values in column B based on unique value in column A

I have the following table:

1 John Doe
  John Doe
2 Adam Smith
  Adam Smith
  Adam Smith

I need to count the number of times a name appears for each number value in column A. The numbers are unique.

Upvotes: 0

Views: 40

Answers (1)

Scott Holtzman
Scott Holtzman

Reputation: 27259

Place this formula in cell C1 and drag down until the end.

=IF(ISNUMBER(A1),COUNTIF(B:B,B1),"")

enter image description here

n.b. - you can more clearly define row numbers instead of using B:B if you like as well

Upvotes: 2

Related Questions