0

I'm not sure how to word this correctly, but I need to get the sequential number on duplicates in google sheets. For example, column Count is what I'm looking for:

+-------+-------+
| Name  | Count |
+-------+-------+
| Joe   |     1 |
| Lisa  |     1 |
| Jenny |     1 |
| Lisa  |     2 |
| Lisa  |     3 |
| Joe   |     2 |
| Jenny |     2 |

Sample sheet: https://docs.google.com/spreadsheets/d/1BB4bzzR3TTAfW5SwvNG_W3AsIYqlSEaSOad5wB4sdko/edit#gid=0

Any help is appreciated, thanks!

sojim2
  • 1,245
  • 2
  • 15
  • 38

2 Answers2

1

For an array-enabled solution, you could try in C1

={"Count"; ArrayFormula(iferror(SORT(ROW(A2:A),SORT(ROW(A2:A),A2:A,1),1)-MATCH(A2:A,SORT(A2:A),0)-ROW()+1))}

For more background, also see this thread.

JPV
  • 26,499
  • 4
  • 33
  • 48
0

Got it, it's: =COUNTIF($A$2:A2,A2)

sojim2
  • 1,245
  • 2
  • 15
  • 38