Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]() Hi all, I have a real lame question about multi-dimensional array operation. Suppose I have defined a two-dimensional array "Array(10,10)". If I want to use the Excel function "Average" to compute the average value of Column, say 10, of that 2D array, is there any way to realize it? I tried "Application.Average(Array(:,10))", but apparently the Excel doesn't like that. (You can see I am a Matlab guy, so please don't laugh at me:) ) Any comments are extremely welcome. -- sammus ------------------------------------------------------------------------ sammus's Profile: http://www.excelforum.com/member.php...o&userid=33092 View this thread: http://www.excelforum.com/showthread...hreadid=529036 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Multicell Array Formula and List Question | Excel Worksheet Functions | |||
Newbie Question: Data/Sort | New Users to Excel | |||
Newbie to charts question - projecting values between data points | Excel Discussion (Misc queries) | |||
Newbie question | New Users to Excel | |||
SUM array formula question | Excel Worksheet Functions |