Hi there,
I have an Excel file with two sheets. Sheet1 has a list of items, which looks like that:
Item 1
Item 2
Item 3
...
Item 2000
Sheet2 has columns, which are named like that:
Item1 Item2 Item 3 ... Item 2000
I need to write a code which for each item in the sheet1 will find the location of the column (i.e. its number or its letter code).
This probably can be done with formulas, but I need a code, as I would like to develop it further.
Re: Assigning item's serial number
Thank you Robert,
The formula has worked perfectly!
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
