K
KevinUK
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
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