MMULT function Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/mmult-function/ Bestselling Excel and Power BI Courses Fri, 17 Mar 2023 00:49:05 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png MMULT function Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/mmult-function/ 32 32 Excel Arrays: Count Unique Items with MMULT, INDIRECT & ROW Functions (Part 3/3) https://www.xelplus.com/excel-array-formulas-count-unique-items-mmult-indirect-row-functions/ Wed, 01 Feb 2017 09:10:00 +0000 https://www.xelplus.com/?p=12680 Consider a scenario, where you need to return a unique count across rows rather than column. You could use the TRANSPOSE function, but in older versions of Excel, TRANSPOSE requires pressing Control Shift Enter (CSE). If you'd rather avoid it, but keep the solution dynamic, you need to look for an alternative. In this tutorial, you will find 3 different solutions based around the ROW function - in combination with INDIRECT, INDIRECT & ADDRESS, and INDEX.

The post Excel Arrays: Count Unique Items with MMULT, INDIRECT & ROW Functions (Part 3/3) appeared first on Xelplus - Leila Gharani.

]]> Excel Arrays: Count Unique Items with MMULT Function (Part 2/3) https://www.xelplus.com/excel-arrays-count-unique-items-with-mmult-function/ Mon, 23 Jan 2017 15:45:00 +0000 https://www.xelplus.com/?p=12705 Learn how to get the unique count across rows using an array formula based on the MMULT and SUMPRODUCT functions.

The post Excel Arrays: Count Unique Items with MMULT Function (Part 2/3) appeared first on Xelplus - Leila Gharani.

]]>