Archive for MMULT function
The formula in cell B17 counts rows in cell range B3:D17 when at least one cell per row contains data. […]
Count cells containing text from list
The array formula in cell F3 counts cells in column B that contains at least one of the values in […]
Filter records that contain numeric values
Liam asks: Hello Oscar, What code is needed to cause cells in Columns F - I to fill with the […]
Count overlapping days across multiple date ranges
NC asks: Thanks a tonne, Oscar. It took me about 8 hours to work through this formula piece by piece, […]
Count overlapping days in multiple date ranges
The MEDIAN function lets you count overlapping dates between two date ranges. If you have more than two date ranges […]
Here comes another post about the MMULT function, today I made a dynamic scoreboard. There are five women competing and there […]
Working with overlapping date ranges
Today's blog post is about date ranges, the techniques demonstrated here can also be applied to time or other numerical […]
Excelxor is such a great website for inspiration, I am really impressed by this post Which numbers add up to […]
The MMULT function calculates the matrix product of two arrays, an array as the same number of rows as array1 and […]
Search each column for a string each and return multiple records – OR logic
RU asks: Can you please suggest if i want to find out the rows with fixed value in "First Name" […]
