+ Reply to Thread
Results 1 to 2 of 2

Performing functions on array while holding dimension constant

  1. #1
    Registered User
    Join Date
    04-06-2010
    Location
    NY
    MS-Off Ver
    Excel 2007
    Posts
    7

    Performing functions on array while holding dimension constant

    What I am trying to do is take the average of values in a 3-dimensional array.

    For example I have an array MyArray(1 to x, 1 to y, 1 to z)

    What I want to do, for example, is obtain the average of the values MyArray(1, 1, 1 to z). Holding the first and second dimension at index 1, and taking the average of the values down the third dimension. Is there any easier way of accomplishing this than by looping through the array and storing the values into another array, and then taking the average of the resulting array?

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Performing functions on array while holding dimension constant

    Hi ath1337,

    Seems to be interesting one...
    Please upload a sample file. Thanks.

    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), [email protected]

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1