Excel Math Wizards

S

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
 
S

scain2004

Thanks,

I had to modify slightly:

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

to get odds, but thanks for your help
 
B

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
 
Top