Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
array formulas
3 views
Skip to first unread message
dpower
Aug 29, 2011, 9:40:22 PM8/29/11
to
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?
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
Aug 30, 2011, 5:06:51 AM8/30/11
to
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
Aug 31, 2011, 12:15:45 PM8/31/11
to
In article
<9842d68e-f884-4785...@fi7g2000vbb.googlegroups.com>,
<9842d68e-f884-4785...@fi7g2000vbb.googlegroups.com>,
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
--
What you are is reward and punishment for what you are.
--Franz Werfel
0 new messages