LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
chi squares Rozie Excel Discussion (Misc queries) 1 June 29th 06 09:52 PM
blue squares blue New Users to Excel 1 February 14th 06 09:46 AM
How do I automatically insert the latin tree names sueCBA Excel Discussion (Misc queries) 3 October 6th 05 03:56 PM
performing least squares Darius Blaszijk Excel Discussion (Misc queries) 5 March 19th 05 07:25 PM
removing squares and lines in squares that really should be paragr finnadat Excel Discussion (Misc queries) 5 February 10th 05 11:12 PM


All times are GMT +1. The time now is 12:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"