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
Microsoft 365
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