Excel Math Wizards

Replace
(ROW(A28)+32)/6

with
(ROW(A7)+8)/3

HTH,
Bernie
MS Excel MVP



"scain2004" <[email protected]> wrote
in message news:[email protected]...
>
> 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 to
> 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 book
> row,4-5,10-7,16-9,22-11).
>
> Any ideas what the formula would be for this?
>
>
> --
> scain2004
> ------------------------------------------------------------------------
> scain2004's Profile:
> http://www.excelforum.com/member.php...fo&userid=7051
> View this thread: http://www.excelforum.com/showthread...hreadid=475145
>

Thanks,

I had to modify slightly:

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

to get odds, but thanks for your help.

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


"scain2004" <[email protected]> wrote
in message news:[email protected]...
>
> Thanks,
>
> I had to modify slightly:
>
> ((ROW(A4) + 8)/3) + 1
>
> to get odds, but thanks for your help.
>
>
> --
> scain2004
> ------------------------------------------------------------------------
> scain2004's Profile:
> http://www.excelforum.com/member.php...fo&userid=7051
> View this thread: http://www.excelforum.com/showthread...hreadid=475145
>