Array formulas with AND and OR logic
In this video, we'll look at how use Boolean algebra in array formulas for AND and OR logic. This is a key skill when building dynamic array formulas...
Dave Bruns
Average hourly pay per day
In this example, the goal is to calculate the average hourly rate per day based on the data shown. All data is in Excel Table named data in the range B5:F16. Note that we want to calculate a weighted average in this case. A weighted average hourly rate is the...Read more
FILTER with boolean logic
In this video, we'll look at how to use the FILTER function with Boolean logic to apply multiple criteria. The result is a filtered list where the color is Blue and the month is June...
XLOOKUP with boolean logic
In this video we'll look how to use the XLOOKUP function with Boolean logic to apply multiple criteria. ...
Tracking COVID-19 with Excel
A quick example of how to track testing for COVID-19 using Excel and publicly available data. In this project, the data is fetched and "shaped" with Power Query, then dropped back into Excel, where it can be refreshed with a single click.Read more
Boolean algebra in Excel
In this video, we’ll look how Boolean algebra is used for AND and OR logic in formulas. In Boolean algebra, there are only two possible results for a math operation: 1 or 0.
How to fix the #SPILL! error
About spilling and the #SPILL! error
With the introduction of Dynamic Arrays in Excel, formulas that return multiple values "spill" these values directly onto the worksheet. The rectangle that...Read more
FILTER data between two dates
In this video, we’ll look at a couple ways to use the FILTER function to extract data between dates.
...
How to perform a random sort
In this video, we’ll look at how to perform a random sort with the SORTBY function, with help from the RANDARRAY function.
...
SEQUENCE of times
In this video, we'll look at how to generate a sequence of times with the SEQUENCE function...