Blog

Auditing & Editing M code (Power Query)
Get & TransformTips

Auditing & Editing M code (Power Query)

Kevin Lehrbass Jul 16, 2019
All Combinations Using Power Query
Get & TransformMacros (vba)

All Combinations Using Power Query

Kevin Lehrbass Jul 13, 2019
Sum Cells in Overlapping Ranges
EfficiencyReviews

Sum Cells in Overlapping Ranges

Kevin Lehrbass Jul 8, 2019
Subtotal helper column
Tips

Subtotal helper column

Kevin Lehrbass May 31, 2019
How many unique List 1 names found in List 2?
ChallengesFormulasGet & Transform

How many unique List 1 names found in List 2?

Kevin Lehrbass May 29, 2019
Power Query solution: partial match count with a condition
Get & Transform

Power Query solution: partial match count with a condition

Kevin Lehrbass May 17, 2019