Ask Your Question

How to get interspersed sequential numbers? [closed]

asked 2013-09-13 03:33:02 +0200

frankaus gravatar image

updated 2013-09-13 13:01:54 +0200

oweng gravatar image

I wish to add a sequential numbers to 1 column at various rows, i.e., 10, 13, 15 the rows in between will have other numbers e.g.,


I want 510066 to go in the next blank cell in the same column.

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-08 08:44:53.147247

1 Answer

Sort by » oldest newest most voted

answered 2013-09-13 13:10:43 +0200

oweng gravatar image

When you say "at various rows", and from the example provided, it appears that the sequential numbers are to be randomly interspersed with other numbers. There does not appear to be a pattern to the rows where the sequential numbers are to occur. Without a pattern, it is impossible to using either a function or macro to produce a solution. Something like the =RANDBETWEEN() function might be useful if the sequential values occur every set number of rows i.e., a value between 1 and 4.

edit flag offensive delete link more


Correct, the only pattern to anything is the sequential number, as in the example, there may be 2 or 20 cells between the sequential number, the only way to do this is last thing to be done is to add the numbers in this column and using sort than cell+1 etc. which i dont want to do as it will take much longer to do. there will be about 2500 rows and i would like to do this line for line.

frankaus gravatar imagefrankaus ( 2013-09-16 05:04:24 +0200 )edit

Question Tools

1 follower


Asked: 2013-09-13 03:33:02 +0200

Seen: 189 times

Last updated: Sep 13 '13