array formulas

[dpower]

I'm crossposting this because there doesn't seem to be much activity in
the .macintosh newsgroup (other than spam). I'm using the Office 2011
for Mac version of Excel on a MacBook, and I'm having trouble creating
an array function for the MODE.MULT statistical function. The help
files say to use the control+shift+return keys to create the function,
but when I use those keys, nothing happens. I've tried following the
instructions on the help page at
<http://mac2.microsoft.com/help/office/14/en-us/excel/item/edc0671b-60d7-
4344-829b-36c2f7d215fa?category=b875ca71-c9e4-4da3-8cd1-bb8549610f18>
to no avail. I've tried to enter the function by hand as
{=MODE.MULT(arrary)} but Excel just stores that as a string not a
function. What am I doing wrong?

I hope this was clear.

 

[Frederic LE GUEN - MVP Excel]

I'm crossposting this because there doesn't seem to be much activity in
the .macintosh newsgroup (other than spam).  I'm using the Office 2011
for Mac version of Excel on a MacBook, and I'm having trouble creating
an array function for the MODE.MULT statistical function.  The help
files say to use the control+shift+return keys to create the function,
but when I use those keys, nothing happens.  I've tried following the
instructions on the help page at
<http://mac2.microsoft.com/help/office/14/en-us/excel/item/edc0671b-60d7-
4344-829b-36c2f7d215fa?category=b875ca71-c9e4-4da3-8cd1-bb8549610f18>
to no avail.  I've tried to enter the function by hand as
{=MODE.MULT(arrary)} but Excel just stores that as a string not a
function.  What am I doing wrong?

I hope this was clear.

Hi,
By hand, nothing works (normal) but have try easy array function like
TRANSPOSE to check if the pb comes from the combination keys Ctrl +
Shift + Enter or from your formula

 

[dpower]

Hi,
By hand, nothing works (normal) but have try easy array function like
TRANSPOSE to check if the pb comes from the combination keys Ctrl +
Shift + Enter or from your formula

Thank you for your prompt reply. I did finally figure out what I was
doing wrong; something stupid. I'm going to go sit in a closet for a
while.

D. Power