Blog

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
3 Newly Added Charts in Excel 2019 You Must Learn to Create
Tips

3 Newly Added Charts in Excel 2019 You Must Learn to Create

Kevin Lehrbass Apr 30, 2019
Partial Match Count with a Condition
Formula or VBATips

Partial Match Count with a Condition

Kevin Lehrbass Apr 22, 2019