ADDRESS function Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/address-function/ Bestselling Excel and Power BI Courses Thu, 02 Mar 2023 09:26:33 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png ADDRESS function Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/address-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.

]]>