Hi Friends,
I am trying to add sequence/following numbers in ColumnA based on cell value in ColumnB.
I been doing it manually, but its taking countless hours to go through thousands of rows.
Thought that I can get some little help here.
Attached the spreadsheet to understand more. ( Hightail Spaces )
Sheet1 Data
13 14
27 1
8 5
Sheet2 output data
13 14
13 14
14 14
15 14
16 14
17 14
18 14
19 14
20 14
21 14
22 14
23 14
24 14
25 14
26 14
27 1
8 5
9 5
10 5
11 5
12 5
I am trying to add sequence/following numbers in ColumnA based on cell value in ColumnB.
I been doing it manually, but its taking countless hours to go through thousands of rows.
Thought that I can get some little help here.
Attached the spreadsheet to understand more. ( Hightail Spaces )
Sheet1 Data
13 14
27 1
8 5
Sheet2 output data
13 14
13 14
14 14
15 14
16 14
17 14
18 14
19 14
20 14
21 14
22 14
23 14
24 14
25 14
26 14
27 1
8 5
9 5
10 5
11 5
12 5