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
Excel Functions
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 REGEXTEST: Check Whether Text Matches a Pattern
Need to check whether text follows a particular format without manually inspecting every cell? The Excel REGEXTEST function can look for patterns…
Read article
Excel REGEXREPLACE: Clean Messy Text With Pattern Matching
Messy data is one of the most common problems in Excel. Phone numbers arrive in different formats, product codes contain unwanted characters,…
Read article
Excel REGEXEXTRACT: Pull Numbers, Codes and Patterns From Text
The Excel REGEXEXTRACT function gives Microsoft 365 users a much more flexible way to pull information from messy text. Instead of building…
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 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
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
TEXTBEFORE vs TEXTAFTER in Excel: Quick Guide
Need to extract part of a text string without building a long combination of LEFT, RIGHT, FIND, or SEARCH formulas? TEXTBEFORE vs…
Read article
Excel LAMBDA: Create Your Own Functions Without VBA
What if you could create your own Excel function without learning VBA or writing a macro? The Excel LAMBDA function lets you…
Read article
How to Use COUNTIF in Excel
COUNTIF is one of the most useful Excel functions when you want to count how many cells match one condition. Microsoft says…
Read article
How to Use SUMIF in Excel
SUMIF is one of the most useful Excel functions when you want to add numbers that meet one condition. Microsoft says you…
Read article- 1
- 2