Hi

I want to add one Latin Square (7*7) to another. To simplify, say I
have two 3*3 arrays:

1 2 3 2 3 1
2 3 1 3 1 2
3 1 2 1 2 3

I want to use Excel to add the second array to the first one, so that
the new one would read

3 5 4
4 4 3
4 3 5

I know this is no longer a Latin Square, but it will be when I do it
for real! I need to do it many times, so am looking to use an Excel
function or formula (I'm very much a novice, as you can probably
tell). Any help very much appreciated.

Kevin

If the top left hand corners of your 2 starting arrays are A2 and J2, then
in the cell where you want the top left hand corner of the result, type
=A2+J2. Copy down and across to fill your array.
--
David Biddulph

"KevinUK" wrote in message
...
Hi

I want to add one Latin Square (7*7) to another. To simplify, say I
have two 3*3 arrays:

1 2 3 2 3 1
2 3 1 3 1 2
3 1 2 1 2 3

I want to use Excel to add the second array to the first one, so that
the new one would read

3 5 4
4 4 3
4 3 5

I know this is no longer a Latin Square, but it will be when I do it
for real! I need to do it many times, so am looking to use an Excel
function or formula (I'm very much a novice, as you can probably
tell). Any help very much appreciated.

Kevin

Highlight the second range of cells, and do COPY, then select the upper-right
cell in the first range of cells and do right-click PasteSpecial Add

Vaya con Dios,
Chuck, CABGx3



"KevinUK" wrote:

Hi

I want to add one Latin Square (7*7) to another. To simplify, say I
have two 3*3 arrays:

1 2 3 2 3 1
2 3 1 3 1 2
3 1 2 1 2 3

I want to use Excel to add the second array to the first one, so that
the new one would read

3 5 4
4 4 3
4 3 5

I know this is no longer a Latin Square, but it will be when I do it
for real! I need to do it many times, so am looking to use an Excel
function or formula (I'm very much a novice, as you can probably
tell). Any help very much appreciated.

Kevin