Dear Excelforum members,
I am trying to create a set of sequences based on a column running like this
1001 I am then looking to build a sequence 100101
1001 by adding "01, 02..nn" untill the number in column A 100102
1001 changes and then the numbers starts again 100103
1002 100201
1002 100202
1002 100203
Any suggestions are much appreciated
Column A Column B
1001 100101
1001 100102
1002 100201
1002 100202
1003 100301
Bookmarks