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.