mixture of do while and for loops

[marko3]

hi im having a bit of problem finding what do while and for loops ive to use to get this code running, basically i have numbers in column 1, first one is around 15000, and there are multiple entries (not all the same) for each one, i want for all the numbers 15000-15007 to return 1, 15008-150014 to return 2, then when the loop gets to 52 it goes back to 1, again,
anyone any ideas on the loops?
thanks

[Domski]

Don't quite follow, can you post a sample workbook showing the layout and expected result?

Dom

[marko3]

Book1.xlsx


so its just basically that,

[6StringJazzer]

Your description above does not match your example. In your description you said that 15000-15007 returns 1, but in your example 15007 returns 2. In your original description the first block 15000-15007 contains 8 numbers and the second block 15008-15014 contains 7 numbers. The point at which you turn around and restart at 1 is 15365. I assumed this was an error and you are working with groups of 7, starting at 15001. (Maybe you are trying to get week numbers from this since you are restarting after reaching 52.)

I have attached an example that does this with a formula and no VBA. Even if my assumption is wrong, this should give you the idea of how this can be done.