View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
KevinUK KevinUK is offline
external usenet poster
 
Posts: 3
Default Adding together two Latin Squares

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