=COUNTIF($B$1:$B1,B1)
A | B | C
=COUNTIF($B$1:$B1,B1) | |
1 | 123 |
2 | 123 |
3 | 123 |
1 | 322 |
2 | 322 |
1 | 555 |
2 | 555 |
3 | 555 |