COLUMN function Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/column-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 COLUMN function Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/column-function/ 32 32 Excel Complex Lookup: Find Header https://www.xelplus.com/complex-lookup-index-sumproduct/ Tue, 05 Sep 2017 09:52:00 +0000 https://www.xelplus.com/?p=11968 In this tutorial we tackle a complex lookup problem - how to return the header based on criteria in a matrix. I offer my solution using INDEX and SUMPRODUCT. We also cover alternative approaches proposed by the Excel community, including an interesting TEXTJOIN solution that is able to handle multiple match results.

The post Excel Complex Lookup: Find Header 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.

]]>