Repeating numbers in a second column

[tommyfernandez]

Hello,

I have two columns: License; LicenseID.

The License column is in ascending order and contains license information, some of which are duplicates. I would like the LicenseID column to start at 1 and continue down in ascending order, but for every duplicate license, repeat that number in the LicenseID column. For example:

abc123, 1
bbc456, 2
bbc456, 2
wwe223, 3
eeq223, 4

Any help with a formula for the LicenseID column what would achieve this task would be much appreciated!

Thank you.

-Tommy

[mehmetcik]

Your example does not help