Hi,
I have a list of items, which looks approximately like that:
Item Name:
Item A
Item A
Item B
Item B
Item B
Item B
Item B
Item C
Item C
There are ~4,000 items in my list and ~2,500 of them are unique items. In the above list unique items are Item A, B and C.
I need to get a code which will assign a serial number to each item. The desired list should look like that:
Item Name: Item Serial Number:
Item A 1
Item A 2
Item B 1
Item B 2
Item B 3
Item B 4
Item B 5
Item C 1
Item C 2
Your help would be much appreciated
