Microsoft Excel Tip #6

In this blog we will discuss multiplying arrays.

First, set up your arrays with the data to be used.

Then, you will want to select the 4×4 box (in this example) where you would want the matrix result to end up.

 

Array Excel 2

 

 

 

In the formula bar, you will type =MMULT(

[Array 1, Array2]) and then, BEFORE hitting enter (which will not work in this instance), you will need to use CONTROL+SHIFT+ENTER (COMMAND+SHIFT+ENTER for Macs) to do the operation (for any and all array functions).

 

Array Excel

 

 

 

If you would like to learn more about this or any Microsoft Dynamics product, please contact Complete Software by calling 410-740-1090 or by emailing support@completesoftware.net!

Based out of Columbia, Maryland, Complete Software Solutions (CSS) is proud to be a Microsoft Partner and Value Added Reseller (VAR) for Microsoft Dynamics GP and Microsoft Dynamics SL as well as a unique software developer providing solutions for businesses and non-profit organizations throughout the country. We offer a variety of services including Microsoft Dynamics consulting, system evaluation, business process analysis, system design, customizations, Enterprise Resource Planning (ERP) implementations and system upgrades.