Home

mmult function

%3CLINGO-SUB%20id%3D%22lingo-sub-770783%22%20slang%3D%22en-US%22%3Emmult%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-770783%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20current%20version%20of%20Office%20365%20only%20requires%20the%20matrix%20product%20function%20mmult(array1%2Carray2)%20to%20be%20entered%20in%20one%20cell%2C%20and%20executes%20when%20Enter%20is%20pushed.%26nbsp%3B%20The%20legacy%20version%20required%20the%20destination%20cells%20to%20be%20selected%2C%20the%20mmult(array1%2Carray2)%20to%20be%20entered%2C%20and%20then%20CTRL-SHIFT_Enter%20pushed%20to%20signal%20matrix%20operation.%26nbsp%3B%20I%20have%20the%20current%20Office%20365%2C%20but%20the%20legacy%20procedure%20must%20be%20used.%26nbsp%3B%20My%20newer%20work%20computer%20with%20Office%20365%20executes%20the%20mmult%20function%20with%20only%20a%20single%20cell%20selected%20and%20enter%20pushed.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-770783%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-772515%22%20slang%3D%22en-US%22%3ERe%3A%20mmult%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-772515%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F381118%22%20target%3D%22_blank%22%3E%40GregWh10%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt%20looks%20like%20on%20work%20computer%20you%20have%20Excel%20with%20Dynamic%20Arrays%20(DA)%20and%20another%20computer%20is%20with%20pre-DA%20Excel.%20Dynamic%20Arrays%20are%20available%20for%20Office%20365%20subscribers%20on%20Insiders%20Fast%20channel%20and%20partly%20on%20Monthly%20(Targeted)%20channel.%20It%20is%20deploying%20step%20by%20step%20now%2C%20but%20who%20knows%20when%20it'll%20be%20available%20for%20all%20channels.%3C%2FP%3E%3C%2FLINGO-BODY%3E
GregWh10
Occasional Visitor

The current version of Office 365 only requires the matrix product function mmult(array1,array2) to be entered in one cell, and executes when Enter is pushed.  The legacy version required the destination cells to be selected, the mmult(array1,array2) to be entered, and then CTRL-SHIFT_Enter pushed to signal matrix operation.  I have the current Office 365, but the legacy procedure must be used.  My newer work computer with Office 365 executes the mmult function with only a single cell selected and enter pushed.

1 Reply

@GregWh10 

 

It looks like on work computer you have Excel with Dynamic Arrays (DA) and another computer is with pre-DA Excel. Dynamic Arrays are available for Office 365 subscribers on Insiders Fast channel and partly on Monthly (Targeted) channel. It is deploying step by step now, but who knows when it'll be available for all channels.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
48 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies