Array manipulation Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/array-manipulation/ 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 Array manipulation Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/array-manipulation/ 32 32 New Excel Functions in Office 365 (VSTACK, TEXTSPLIT, TOCOL, DROP, WRAPCOLS, CHOOSECOLS, TAKE) https://www.xelplus.com/new-excel-functions-vstack-textsplit-tocol/ Thu, 31 Mar 2022 05:20:00 +0000 https://www.xelplus.com/?p=9390 Excel recently released a set of new functions like VSTACK, TEXTSPLIT and TOCOL that will have you looking forward to working with complex files and data because your life just got more exciting (at least mine did!).

The post New Excel Functions in Office 365 (VSTACK, TEXTSPLIT, TOCOL, DROP, WRAPCOLS, CHOOSECOLS, TAKE) appeared first on Xelplus - Leila Gharani.

]]> 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.

]]>