I am wanting to create a new product ID based on the contents of another cell in the sheet - see example for what I need to do - basically a product ID (starting at 4214) needs to be allocated to the items based on the number in Column C - so where the same number is shown in column C then the same product ID would show. Each time the number in column C changes then the new product ID increases by one.
Any suggestions (the simpler the better) would be appreciated.
In the sample spreadsheet I have duplicated the data (columns A-D) in columns G-J to show how I want the data to show when the formula is run.
Hope that makes sense. Fingers crossed someone can help as otherwise I will need to do this manually on a rather large spreadsheet which will likely incur one or two errors.
Bookmarks