ROW function Archives - Xelplus - Leila Gharani

Number Rows in Excel – Dynamic Solution with SEQUENCE

Leila Gharani — Tue, 26 Sep 2023 14:08:36 +0000

Learn how to create self-numbering lists for Excel tables and traditional lists using the SEQUENCE function.

The post Number Rows in Excel – Dynamic Solution with SEQUENCE appeared first on Xelplus - Leila Gharani.

Return Multiple Match Values in Excel

Leila Gharani — Thu, 30 Aug 2018 10:26:00 +0000

What to do when VLOOKUP falls short? It can't return multiple match results. But there are formulas that can. Here, I show you 2 different methods that return multiple matches: a combination of INDEX & AGGREGATE, which are available in all Excel versions, and TEXTJOIN, which was first introduced in Excel 2016 and Office 365.

The post Return Multiple Match Values in Excel appeared first on Xelplus - Leila Gharani.

Excel Arrays: Count Unique Items with MMULT, INDIRECT & ROW Functions (Part 3/3)

Leila Gharani — Wed, 01 Feb 2017 09:10:00 +0000

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.

8 Formulas to get Unique Count Across Rows in Excel (Part 1/3)

Leila Gharani — Thu, 19 Jan 2017 08:11:00 +0000

Learn how to get the unique count across rows using an array formula based on the SUMPRODUCT and FREQUENCY functions.

The post 8 Formulas to get Unique Count Across Rows in Excel (Part 1/3) appeared first on Xelplus - Leila Gharani.