=INDIRECT("Sheet1!"&"R"&1+INT((ROW()-1)/70)&"C"&(3*MOD(ROW()-1,70)+COLUMN()),FALSE)

when figuring it out I used this formula
=1+INT((ROW()-1)/70)&"-"&3*MOD(ROW()-1,70)+COLUMN()
which returns something like this
1-1,1-2,1-3
1-4,1-5,1-6
....
1-208,1-209,1-210
2-1,2-2,2-3
and then put that in the indirect function in R1C1 format.

"tx12345" wrote:


=INDIRECT("Sheet1!"&"R"&1+INT((ROW()-1)/3)&"C"&(3*MOD(ROW()-1,3)+COLUMN()),FALSE)

nice formula, but it only works with 3 sets (abc, def, ghi) I have up
to 70 sets of three to track. I have tinkered with the formula, but no
matter what i do it screws it up. If i leave it alone it only picks up
the three sets, abc, def, ghi. Any way to expand the formula to
include up to 70 sets of three, i.e., jkl, mno, pqr etc etc etc

Thx


--
tx12345
------------------------------------------------------------------------
tx12345's Profile: http://www.excelforum.com/member.php...o&userid=24776
View this thread: http://www.excelforum.com/showthread...hreadid=493109