Excel Math Wizards

[scain2004]

Ok, I currently have the following formula:


Code
-------------------
=CONCATENATE(INDIRECT("'Gross%'!A" & (ROW(A28)+32)/6), " ", INDIRECT("'Gross%'!B" & (ROW(A28)+32)/6)
-------------------


The blue portion is what needs to be changed.

It references another sheet in the book and worked fine until I had t
modify the other sheet to add a row between all existing rows.

The initial sheet uses this formula on every sixth line (4,10,16,22
etc.). The source sheet holds the data on every odd line (5,7,9,11).

The correlation between books is constant. (child book row-parent boo
row,4-5,10-7,16-9,22-11).

Any ideas what the formula would be for this

 

[Bernie Deitrick]

Replace
(ROW(A28)+32)/6

with
(ROW(A7)+8)/3

HTH,
Bernie
MS Excel MVP

 

[scain2004]

Thanks,

I had to modify slightly:

((ROW(A4) + 8)/3) + 1

to get odds, but thanks for your help

 

[Bernie Deitrick]

They're equivalent:

(ROW(A7)+8)/3 = (7+8)/3 = 15/3 = 5

((ROW(A4) + 8)/3) + 1 = (4+8)/3+1 = 12/3+1=4+1=5

HTH,
Bernie
MS Excel MVP