it's a /9 (3 squared)



so if i have 5 variables per column on sheet 1, on sheet 2 it's "/5" and i
fill down to f25, and then on sheet three its "/25" fill down to c625, and
sheet 4 its "/25" and fill down to 15625 .... do i have that right?

thanks again


"iart" wrote:

ok, looks great. but i had one question:

let's say there are three, or 5 variables, what do i revise? for example on
sheet three the formula is:

=OFFSET(Sheet2!$A$1,INT((ROW(A1)-1)/4),)&"-"&OFFSET(Sheet2!$B$1,INT((ROW(A1)-1)/4),)

if i am guessing right, the "/4" near the end there is the result of the
fact that this sheet only has three columns and there are 12 numbers,
therefore 3x4=12? so if there were 18 total (3 per column in sheet 1) the"/4"
would change to "/6"?

Looks very promising. Thnaks again