LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 43
Default Rules for element-by-element product in array multiplication

I've read up on array formulas on the web, and experimented with
multiplying vector array constant with different lengths and
orientations. Regardless of the order in which they appear in the
expression, if a M-tall array constant is multiplied with a N-wide
array constant, the result is an M-tall, N-wide matrix. The result at
the mth row and nth column is the product of the mth element from the
tall vector and the nth element from the wide vector. How universal
is this? Can this be relied upon to hold in all situations? I got
the vertical vectors using TRANSPOSE().

Things get complicated if I multiply 2-D array constants of differing
dimensions. Does anyone know the rules for this? Does it actually do
anything useful enough to be exploited?

Finally, I noticed that one can specify a target area for the array
multiplication that differs in size from the resulting matrix. If it
is too small along a certain dimension, the matrix simply gets
truncated along that direction. If it is too big, the extra cells are
filled with #N/A. Is there a way to show the boundary of cells over
which an array formula is specified?

Thanks.
 
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
Looping through each element of an array Conan Kelly Excel Programming 3 March 3rd 06 10:30 AM
Permutations of an array element < to a value Bruce Excel Worksheet Functions 3 January 31st 06 04:00 PM
Array problem: Key words-Variant Array, single-element, type mismatch error davidm Excel Programming 6 November 9th 05 05:54 AM
Array problem: Key words-Variant Array, single-element, type mismatch error davidm Excel Programming 1 November 8th 05 04:21 AM
Array element Andrea[_8_] Excel Programming 5 December 7th 04 08:24 PM


All times are GMT +1. The time now is 12:01 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"