Sequence of duplicate values

[sofas]

Hello. I am looking for a formula or code that enables me to sequence the invoice numbers in column A, knowing that the invoice number is repeated several times as follows:

Invoice numbers format
3457888
5670877
4357888
6783216
3457888
3457888

It must be extracted as follows, in column b, taking into account repetition, perhaps up to 40 times


3457888 (1)
5670877 (1)
4357888 (1)
5670877 (2)
3457888 (2)
3457888 (3)

 

[DanteAmor]

Try

Dante Amor
	A	B
1	Number	Sequence
2	3457888	(1)
3	5670877	(1)
4	4357888	(1)
5	5670877	(2)
6	3457888	(2)
7	3457888	(3)
Hoja1

Cell Formulas
Range	Formula
B2:B7	B2	="("&COUNTIF($A$2:A2,A2)&")"