ROWS function Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/rows-function/ Bestselling Excel and Power BI Courses Thu, 09 Mar 2023 12:07:41 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png ROWS function Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/rows-function/ 32 32 Quick Excel Trick to Unstack Data from One Column to Multiple Columns https://www.xelplus.com/unstack-data-to-multiple-columns/ Sat, 12 Jan 2019 02:15:00 +0000 https://www.xelplus.com/?p=9820 Find out the quickest way to unstack data in Excel from one column to multiple columns. You don't need complicated excel formulas or VBA. Find out how in this tutorial.

The post Quick Excel Trick to Unstack Data from One Column to Multiple Columns appeared first on Xelplus - Leila Gharani.

]]> Return Multiple Match Values in Excel https://www.xelplus.com/return-multiple-match-values-in-excel/ Thu, 30 Aug 2018 10:26:00 +0000 https://www.xelplus.com/?p=9715 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.

]]>