using Count if to sub number

[k_babb]

hi i have a large problem which hopefully someone can solve
i have a list of invoice numbers in which lots are duplicated what i want to do is insert a new column next to the invoice numbers and then sub number them so that if an invoice is duplicated it will be numbered in the second column for example

invoice no. Subno.
12345 1
12345 2
12345 3
14000 1
50000 1
50000 2
60000 1

i have over 14000 records so some sort of macro would be good

thanks for your help

[Bob Phillips]

Try

=COUNTIF(A$2:A2,A2)

[Marcol]

Try this in B2

Please Login or Register  to view this content.

Drag/Fill Down

or if you only want to find the duplicates maybe

Please Login or Register  to view this content.

This is easier to visually detect.

Use C/F to highlight any specific count and filter to get the result/info you need'

Hope this helps.

[k_babb]

tried that does not work as i need it to count the amount of entries and then number them so if there are 15 invoices with the number 11111 then in the sub column it would have 1 by the first entry 2 on the second and so on

[Bob Phillips]

tried that does not work as i need it to count the amount of entries and then number them so if there are 15 invoices with the number 11111 then in the sub column it would have 1 by the first entry 2 on the second and so on

Which is exactly what our formula (mine and Marcol's first) does.

[k_babb]

Works a treat thank you so much

[Marcol]

On behalf of both.

Happy to have helped ...