SOLVED - Need help with a non-sequential number pattern

So where do you want these numbers to appear? (Which cells?)

Pete

Put the number 1 in A1, and this formula in A2:

=IF(MOD(ROWS($1:2)+7,8)=0,INT((ROWS($1:2)-1)/8+1),A1+8)

This will give you the pattern you require up to 64, but beyond there it will repeat. Do you need to have numbers beyond 64, and if so will they follow the above pattern but with 64 added on for the next block of 64 (and then 128 added on for the block after that etc.)?

Hope this helps.

Pete

Pete,

This is VERY helpful. Thank you. Yes, I will need more than 64. Ha. This is going to be a heavily attended event, and people can be given multiple vouchers. So, I will probably need something on the order of 15,000. Which I is why I didn't want to have to enter all the numbers manually. Especially as I am just volunteering. (When I took on the assignment, no one was asking for numbering. Joke's on me.)

So, yes, I need this to go to a very high number.

Okay, I'll get back to you later - it's half-time in the football match at the moment.

Pete

Pete,

I cannot express my thanks to you enough. You are my hero for the day! Thank you, thank you, thank you!

Mindy

Hi Mindy,

put this revised formula in A2:

=IF(MOD(ROW()+7,8)=0,INT((ROW()-1)/8)+1+INT((ROW()-1)/64)*64+INT((ROW()-1)/4096)*4096,A1+8)

then copy it down. This will repeat again only after 4096*4096, or 16.78 million, and as there aren't that many rows in an Excel sheet then you should be okay.

Hope this helps.

Pete

Pete,

Thanks for your work on this. I noticed when I put this formula in that it often skips a bunch of numbers. After the sequence "8, 16, 24, 32, 40, 48, 56, 64" it doesn't go back to 9. It skips up to 73. There are a number of large jumps like this. Instead of going from 80 back to 81 it jumps up to 145, etc. When I tried going to 15000, the final number showing was 29140. It definitely kept the pattern all the way to the bottom, however it just often skipped a whole bunch of numbers.

Mindy

Hi Mindy,

I've tried all sorts of formulae, but I think the simplest solution will be to use the first formula I gave you in A2 and copy that down to cell A64. Then in cell A65 put this formula:

=A1+64

and copy that down to cell A4096. Then in cell A4097 put this formula:

=A1+4096

and copy that down as far as you need to.

Hope this helps.

Pete

If anyone can help me with this ASAP I would greatly appreciate it. I am working on a deadline. Ugh, I wish I hadn't been so stupid to start with.

I tried manually filling in about half the sequence to see if Excel would recognize it and fill the rest in, but no luck.

Pete, thanks so much for all that work. Your formula did exactly what I asked for. I was just being a moron and didn't know what I was asking for.

Mindy

That list is definitely much closer. Thanks. But, the round numbers are not right. Look at the 800 row. That should be the number 800. The round numbers there should be 100, 200, 300, 400, 500, 600, 700, 800. The row of 1600 should be number 1600. Etc. The whole sequence gets weird around those round numbers.

And it weirdly makes a leap at number 4795. Instead of going back to 4096, it goes up to 4796. It makes another weird leap in the "95" section of the next sequence, too. Haven't looked at anything past those. Actually, after a quick glance, it gets really weird at the "95" section of every sequence. For some reason, it seems to jump to the next 800 numbers for numbers ending in "95-00". How weird.

But, this is workable. I will have to manually fill in some of the missing numbers. And re-sequence a few. Still, it shouldn't take too long.

If anyone can give me one that is fully accurate with which to compare, that would be great for proofreading.

Thanks!

PS. Actually, my Excel program is filling in the series for me in those "90" endings where that chart gets weird. So, I am not having to do much extra formatting.

Thanks so very much! Thank you, thank you, thank you!!!!

Perfect!

Pete and Dave, I cannot thank you enough for this work. It has helped me out tremendously. Thank you so very much!

Mindy