Looping

[bgcogen]

Hi.
More of an Excel question, but someone might be able to help??

Basically I have a column of cells whose value is determined by the formula =B2 & C3 & C3 and the next cell - =B2 & C4 & C4 and then =B2 & C5 & C5 and so on.

So that the first part always stays the same, and the last two parts increment by one. However, when I try that draggy down thing it increments the B part too, which I want to remain the same.

What can I do??

Thanks,
D

 

[Fizzio]

Try changing the initial formula to

=$B$2 & Cn & Cn (n is the initial number)

The $ sign represents a static cell (I think)