How do I continue this pattern in excel?

G

Guest

It seems like a simple thing to do but I just can't continue this pattern in
excel. I'm sure it's just copying and pasting but I'm stuck. Also each is a
4X4 matrix:
=B12 =C12 =D12 =E12
=F12 =G12 =H12 =I12
=J12 =K12 =L12 =M12
0 0 0 1
=B13 =C13 =D13 =E13
=F13 =G13 =H13 =I13
=J13 =K13 =L13 =M13
0 0 0 1
Does anyone have any suggestions as to how to repeat this pattern
vertically? thank you.
-Greg K.

R

Ragdyer

Does this work for you?

=INDEX(\$12:\$12,ROW(2:2))

And copy down.

G

Guest

Greg K. said:
It seems like a simple thing to do but I just can't continue this pattern in
excel. I'm sure it's just copying and pasting but I'm stuck. Also each is a
4X4 matrix:
=B12 =C12 =D12 =E12
=F12 =G12 =H12 =I12
=J12 =K12 =L12 =M12
0 0 0 1

G

Guest

I don't think that's exactly what I'm looking for or I may be copying down
wrong, but thank you anyway ragdyer. Any other suggestions would be greatly
appreciated.
-Greg

H

Harlan Grove

It seems like a simple thing to do but I just can't continue this
pattern in excel. I'm sure it's just copying and pasting but I'm
stuck. Also each is a
4X4 matrix:
=B12 =C12 =D12 =E12
=F12 =G12 =H12 =I12
=J12 =K12 =L12 =M12
0 0 0 1
=B13 =C13 =D13 =E13
=F13 =G13 =H13 =I13
=J13 =K13 =L13 =M13
0 0 0 1
Does anyone have any suggestions as to how to repeat this pattern
vertically? thank you.

If you want the B12 result in, say, X99 so that the L12 result would be in
Z101, then use the formula

X99:
=IF(MOD(ROWS(X\$99:X99),4),INDEX(\$B\$12:\$M\$13,
INT((ROWS(X\$99:X99)-1)/4)+1,MOD(ROWS(X\$99:X99)-1,4)*4
+COLUMNS(\$X99:X99)),--(COLUMNS(\$X99:X99)=4))

Select X99 and fill right and down into X99:AA106.

G

Guest

I should have been more clear in my question but I need to find a way to
continue this pattern (as stated in my last 9/3 post) rather than actually
copy and paste it somewhere else. (I want to be able to drag this pattern
down until row 523).
=B12 =C12 =D12 =E12
=F12 =G12 =H12 =I12
=J12 =K12 =L12 =M12
0 0 0 1

=B14 =C14 =D14 =E14
=F14 =G14 =H14 =I14
=J14 =K14 =L14 =M14
0 0 0 1

. . . .
. . . .
. . . .
=B523 =C523 =D523 =E523
=F523 =G523 =H523 =I523
=J523 =K523 =L523 =M523
0 0 0 1
Does anyone have any suggestions as to how to repeat this pattern
vertically as in 14,15,16...523. with the last row always being 0 0 0 1 ?
I apologize to Harlan for not being as clear as I should have been.
Does anyone have an idea of how to do this? Feedback ASAP would be greatly
appreciated. Thank you.
-Greg

R

Ragdyer

If that's all you want to do, just select the *entire first* set, grab the
"fill handle" of that 16 cell selection, and drag down to copy.

Works for me!

G

Guest

Doesn't that give you:
because you are going down 4 columns from the previous 16 cell set? Is it
possible to get the B13 set next instead of the B16 cell set or am I doing
something wrong?
-Greg

R

Ragdyer

Let's start from the beginning, so that we're both talking about apples, and
*not* apples and oranges.

How are you entering the data
=B12
into a cell?
AND ...
Exactly what is
=B12
?

Is it a formula ...
Is the cell it's entered into pre-formatted as Text?
Is the cell it's entered in formatted as General, and the data is prefixed
with an apostrophe?

My data was copied into a new sheet, into Text pre-formatted cells, from

I just manually entered your data into General formatted cells, prefixed
with an apostrophe ... AND ... the copy results were identical to my first
test ... *EXACTLY* what you're looking for.

So, my results were attained on Text values.

SO ... What exactly is the form of your data?

R

Ragdyer

Just manually entered all your data as *formulas* into "General" formatted
cells, and I *did* get the same results as you ... B12 incremented to B16
during a "copy".

Enter the primary set of data as text, complete your copying, then transform
the entire range to formulas.

Format your primary *12* cells to Text.
Leave the 0 - 0 - 0 - 1 row as General.

Select the entire range of copied data.
<Ctrl> <Shift> < ~ >
To change the format of the range to General,
Then, while everything is *still* selected,
<Edit> <Replace>
Find what, enter
=
Replace with what, enter
=
Then click "Replace All".

You should now have what you're looking for.

G

Guest

Thank you very much Ragdyer.
-Greg

Ragdyer said:
Just manually entered all your data as *formulas* into "General" formatted
cells, and I *did* get the same results as you ... B12 incremented to B16
during a "copy".

Enter the primary set of data as text, complete your copying, then transform
the entire range to formulas.

Format your primary *12* cells to Text.
Leave the 0 - 0 - 0 - 1 row as General.

Select the entire range of copied data.
<Ctrl> <Shift> < ~ >
To change the format of the range to General,
Then, while everything is *still* selected,
<Edit> <Replace>
Find what, enter
=
Replace with what, enter
=
Then click "Replace All".

You should now have what you're looking for.

R

Ragdyer

Glad it all got squared away.

The largest hurdle in these groups is not having to *solve* the problems,
but in the OP's ability to make their problem comprehensible to a large,
varied congregation, and in that congregation's adeptness to interpret the
OP's often abbreviated and/or awkward attempts at an explanation of their
predicament.

Thanks for the feed-back.