I have excel file that has 2 rows

Row 1 has records
A
A
A
B
B
C
A
Row 2 need to have the number of times row one repeats a record.
Something like this
1
2
3
1
2
1

Any formula that will find records on column one and sequentially number
column B depending on amount of records?

Thank you

-RoMo