Calculating formula between two numbers

[Lisa Gero]

Hey guys,

i have got a formula in C1. Now, i want to calculate the formula between two numbers (minimum A1 and (maximum B1.
I can pull the formula to the right manually, but i always need to pull the formula till i hit the maximum number from B1.
And..the longer the differences between the numbers the longer is the column (f.ex.: from C1 to XYZ1).

It is very annoying to pull the formula with my hand. For this reason, i want to ask you, whether there is any possibilty to calculate the formula automatically. it should start calculating with the number from A1 and stop with B1.

Sorry for my english, im still practising ;-)

best regards

Lisa

[ChemistB]

Is it incremental (i.e if A1 is 5 and B1 is 25, in C1,D1,E1... 5,6,7?

You could have this formula in your sheet
In C1 = A1
In D1 copied to the right
=IF(OR(C1="", C1=$B1),"", C1+1)

Does that work for you?
Your English is fine.

[ragulduy]

What is the formula?

[Lisa Gero]

Hi ChemistB,

your formula is working so far. Thanks!
First problem solved

But my second point is copyingpart to the right.
As you already said correctly, it is incremental in 0,01 steps. So i maybe got some hundred of columns from C1 to XYZ999...
Furthermore i got quite a few data sets A1 to B1, A2 to B2 and so on.. which all have a different columnlength and i need to do the same procedure here.
But i don't want to copy the formula to the right one thousand times ;-)

Is there any possibilty to get a macro in vba or another excel formula, which only calculates the columns between the numbers in A1 to B1 and after reaching the last number from B1 stopping calculate?

Hope, you got it.

[ragulduy]

You can use VBA code along with the resize function to essentially do this.

i.e.

Please Login or Register  to view this content.

Will reference 100 columns from A1.

So if you 5 in A1 and 125 in B1 then you could do something like

Please Login or Register  to view this content.

which would put 5 to 125 from C1 to DS1 and then =5*C1, =5*D1 etc formula in C2:DS2

[Lisa Gero]

This is perfect, thank you both!

[Lisa Gero]

Final question. What do i need to change when i have got 0.01 steps (i.e. 0,01 0,02 ..0,99 1) and not 1 steps (1 2 3..)?

[ragulduy]

Please Login or Register  to view this content.