create a range from two value macro

[skimura]

Ok im trying to have excel create a rage of numbers from the given values in cells b1and b2. I would like to add 11 to b1 till the last digit is 6 then add 4 to only that number then continue to add 11 till the last digit is a 6 then add 4 again then back to adding 11 and so on till the value in b2 is reached I have attached my file for an example in addition to the below.

When given the values of 60862620 and 60862922 once 60862686 is reached then 4 would need to be added then after that 11 would need to be added till another number ends with 6 then 4 is added. EXAMPLE:

60862620 +11
60862631 +11
60862642 +11
60862653 +11
60862664 +11
60862675 +11
60862686 +4
60862690 +11
60862701 +11
60862712 +11
60862723 +11
60862734 +11
60862745 +11
60862756 +4

[Marcol]

Try this in E2

Please Login or Register  to view this content.

Is that what you mean?

Or is this the correct formula

Please Login or Register  to view this content.

Your data appears to conflict with your description

[skimura]

Try this in E2

Please Login or Register  to view this content.

Is that what you mean?

Or is this the correct formula

Please Login or Register  to view this content.

Your data appears to conflict with your description

this does not seem to keep the sequence. Basically i just need it to add 11 to the start number then and keep adding 11 till it reaches a number ending in 6 then add 4 to only that number then add 11 till it reaches another number ending in 6 then add 4 again and so on till the end number is reached.

[Cutter]

I think you want:

Please Login or Register  to view this content.

[Marcol]

The problem seems to be, that in Post#1 you ask to add 4 when the last digit is 6, but in your sample workbook you seem to want to add 6 when the last digit is 6

You then, perhaps by accident, provide a pattern that repeats, every 7 rows (6 @ +11, then 1 @ +4 (or +6))

I think we need some better explanation of your rules

@ Cutter your formula and my second suggestion return the same result provided that we know if it is to be C2+4 or C2+6

[Cutter]

Marcol

Yep, I realize that. Just providing an alternative (based solely on his samples in OP, I didn't look at his file and, therefore, didn't see discrepancies).

From his OP it wasn't even clear if he wanted VBA for this but I assumed not when he tried your solution and couldn't get it to work.

[Cutter]

Now, after looking at the sample file I would suggest this formula in C3 copied down as far as is necessary:

Please Login or Register  to view this content.

if 4 is to be used for numbers ending in 6. Otherwise change the "C2+4" part to "C2+6" or whatever other number you want.

[Marcol]

No problem Cutter just wish at times a little more thought could be applied before questions are asked, sometimes the old way, dare I say paper and pencil, might be advantageous.

It was the last line in the sample

60862763 +6

That made me think a series might be involved

[Cutter]

There are actually 2 lines in the sample showing +6 but I assume the error in thinking is the 6 because he was thinking of the last digit being a 6 as a trigger.

In any event I'll offer an amended formula:

Please Login or Register  to view this content.

just to cover any errors.

[skimura]

There are actually 2 lines in the sample showing +6 but I assume the error in thinking is the 6 because he was thinking of the last digit being a 6 as a trigger.

In any event I'll offer an amended formula:

Please Login or Register  to view this content.

just to cover any errors.

Sorry my mistake Yes i mistyped i need 4 added not six sorry for the confusion. But I thank you all for the work on this cause it works great thank you!!!