How do I Increment a particular woksheet number?

N

nicolai

I have the following entry:
=CONCATENATE(Master!$R$2,Master!$R$3,A4,Master!$R$4,Master!$C$4)

I would like the successive lines to increment both the A4 (which it
does) but also the final Master!C$4. I would like the column to look
like this when I'm done dragging it down:

=CONCATENATE(Master!$R$2,Master!$R$3,A4,Master!$R$4,Master!$C$4)
=CONCATENATE(Master!$R$2,Master!$R$3,A5,Master!$R$4,Master!$C$5)
=CONCATENATE(Master!$R$2,Master!$R$3,A6,Master!$R$4,Master!$C$6)
=CONCATENATE(Master!$R$2,Master!$R$3,A7,Master!$R$4,Master!$C$7)
etc....

Is there a way to write it so that the final number also increments
when I drag it down?

Thanks in advance.

Nicolai
 
N

nicolai

Ok, I figured it out.... I remove the $.
(...Master!$C4 instead of ...Master!$C$4)
 
O

Otto Moehrbach

If I read what you have and what you want correctly, just remove the dollar
sign($) that you have in front of the 4. That will cause the 4 to
increment. Having the dollar sign specifically tells Excel to not increment
the 4. HTH Otto
 
Top