Excel GROUPBY: Create Summary Tables Without a PivotTable
Excel GROUPBY gives Microsoft 365 users a new way to summarize data without manually creating a PivotTable or building separate UNIQUE and…
Read article
Blog · Tag
Dynamic Arrays
GROUPBY vs PIVOTBY in Excel: What’s the Difference?
GROUPBY vs PIVOTBY in Excel can be confusing because both functions summarize data, both can calculate totals, and both can create results…
Read article
Excel PIVOTBY: Build Pivot-Style Summaries With a Formula
The Excel PIVOTBY function can create a two-dimensional summary using a normal formula. You can group information by rows and columns, calculate…
Read article
Excel FILTER Function: Create Lists That Update Automatically
Need a list in Excel that automatically changes when your source data changes? The Excel FILTER function can return only the rows…
Read article
Excel SORT vs SORTBY: What’s the Difference?
Excel gives you two modern functions for sorting data dynamically: SORT and SORTBY. They sound almost identical, but there is an important…
Read article
TOCOL vs TOROW in Excel: Reshape Data Quickly
Have data spread across several rows and columns but need it converted into one simple list? TOCOL vs TOROW in Excel gives…
Read article
WRAPROWS vs WRAPCOLS in Excel: What’s the Difference?
Have one long Excel list that you want to turn into a cleaner table? WRAPROWS vs WRAPCOLS gives you two similar functions…
Read article
Excel WRAPROWS: Turn One Long List Into a Table
Have a long list of values that would look much better arranged across several rows and columns? The Excel WRAPROWS function can…
Read article
Dynamic Arrays in Excel: What Does the #SPILL! Error Mean?
You enter a formula in Excel expecting a result, but instead you see #SPILL!. The Excel #SPILL! error is usually connected to…
Read article