# Fill custom series of numbers with respect to a specific variable number

1. ## Fill custom series of numbers with respect to a specific variable number

Hi,

Let me explain my issue.

On excel sheet1 in cell BY7, i want to put a number say 10. Now i want that below it following pattern of numbering series should be filled
11 to 59 then
0 to 59 (again and again in a loop, 120 times)

In Cell BY7 number is variable, means if i put a number 50 then series should be filled like this
51 to 59 then
0 to 59 (again and again in a loop, 120 times)

2. ## Re: Fill custom series of numbers with respect to a specific variable number

You could do this with a formula in BY8:

``Please Login or Register  to view this content.``
Then copy all the way down to BY126. Alternatively:

``Please Login or Register  to view this content.``
WBD

3. ## Re: Fill custom series of numbers with respect to a specific variable number

Thanks a lot Sir,

It worked. i was trying a way to do this since yesterday.

I am really thankful to you sir.

4. ## Re: Fill custom series of numbers with respect to a specific variable number

Hi Sir,

I want to make a update in this series.

On excel sheet1 in cell BY7, i want to put a number say 35. Now i want that below it following pattern of numbering series should be filled
7 to 31 ( 31-7=24 why 24 because 59-35=24 , Here 59 is always constant number and 35 is the variable number that i will change) then
32 should not be written next then
33 to 92 (gap of 59) then again
93 should not be written next then
94 to 153 (gap of 59) then again (and so on this way)

5. ## Re: Fill custom series of numbers with respect to a specific variable number

Not sure how many occurrences of the 59-gap sequence you want. Again, two solutions. Formula for BY8:

``Please Login or Register  to view this content.``
Or Macro:

``Please Login or Register  to view this content.``
WBD

There are currently 1 users browsing this thread. (0 members and 1 guests)