Sorry about the cross post but I'm getting desperate...

row 1 contains headers. col A and C contain values. I need to populate Col B
with values like the following

B2 needs to read R2C3
B3 needs to read R2C4
B4 needs to read R2C5
B5 needs to read R3C3
B6 needs to read R3C4
B7 needs to read R3C5
B8 needs to read R4C3
B9 needs to read R4C4
B10 needs to read R4C5

etc...

I was given...
=OFFSET($C$4,INT((ROW(A1)-1)/3),MOD(ROW(A1)-1,3))

But it's not working because of the values that I have in columns A and C.


Any and all help is greatly appreciated.

check your other post for another suggestion.

"Stephen" wrote:

Sorry about the cross post but I'm getting desperate...

row 1 contains headers. col A and C contain values. I need to populate Col B
with values like the following

B2 needs to read R2C3
B3 needs to read R2C4
B4 needs to read R2C5
B5 needs to read R3C3
B6 needs to read R3C4
B7 needs to read R3C5
B8 needs to read R4C3
B9 needs to read R4C4
B10 needs to read R4C5

etc...

I was given...
=OFFSET($C$4,INT((ROW(A1)-1)/3),MOD(ROW(A1)-1,3))

But it's not working because of the values that I have in columns A and C.


Any and all help is greatly appreciated.

got it! Thank you. I'm cross posting the solutions that worked for me in
hope that others can benifit too. It amounts to either using a marco

Sub test()
Row = 2
a = 2
Do
For i = 3 To 5
Cells(Row, 2).Value = "R" & a & "C" & i
Row = Row + 1
Next i
a = a + 1
Loop Until Row 735
End Sub


or one of two formulas...

="R"&INT(ROW(A3)/3)+1&"C"&MOD(ROW(A2)+1,3)+3

or without the cell references...

="R"&INT((ROW()+4)/3)&"C"&MOD(ROW()+1,3)+3

I ended up using the macro so I did not have to convert the formulas into
their values.

Thank you to everyone for their input.


"JMB" wrote:

check your other post for another suggestion.

"Stephen" wrote:

Sorry about the cross post but I'm getting desperate...

row 1 contains headers. col A and C contain values. I need to populate Col B
with values like the following

B2 needs to read R2C3
B3 needs to read R2C4
B4 needs to read R2C5
B5 needs to read R3C3
B6 needs to read R3C4
B7 needs to read R3C5
B8 needs to read R4C3
B9 needs to read R4C4
B10 needs to read R4C5

etc...

I was given...
=OFFSET($C$4,INT((ROW(A1)-1)/3),MOD(ROW(A1)-1,3))

But it's not working because of the values that I have in columns A and C.


Any and all help is greatly appreciated.