XLOOKUP is one of the most useful tools in Excel, but doesn’t allow you to use multiple variables/criteria.
Here I show three ways to make this work:
– Use a SUMIFS
– Use a helper column
– Nest an XLOOKUP inside another XLOOKUP
How to do an XLOOKUP with multiple variables Read More »
Learn how to make a goal tracker in Excel in minutes!
Great for:
– Weight loss
– Exercise targets
– Self-improvement
– Learning a skill
– Reading X books per year
– Sending out a certain number of sales pitches per week
Make a Goal Tracker in Excel in 11 Minutes Read More »
Figuring out how to make a Dungeons and Dragons encounter hard enough to be a challenge to the players, but not so hard that it kills the entire party, is quite difficult. The method for doing so involves a lot of trial and error and repetitive math. Here I walk you through creating an Excel
Build a Dungeons and Dragons encounter tool in Excel – an XLOOKUP tutorial Read More »
