Running Totals
A running total is the summation of the current and previous numbers in a column. It’s a useful way of keeping track of sales figures over a time period or for monitoring the balance on a bank statement. Have a…
Generate Unique Random Numbers
The RANDBETWEEN function provides a non-dynamic array solution to creating a set of random numbers. It returns an integer between the minimum and maximum values you specify. The problem is, however, it is likely to return duplicates after each worksheet…
Non-Dynamic Array Functions
Many Excel functions are dynamic array-friendly, meaning they are capable of returning a spilled range. This isn’t just true for newer ones such as FILTER, SORT, and UNIQUE, but others as well like MATCH, LEFT, and LEN. Unfortunately, some aren’t….
How Do Excel File Types Perform?
It’s probably not something you give much thought about, but awareness of the different Excel file types is important, so you can avoid limitations and data loss. Before Excel 2007, the default file format was XLS (.xls); this was then…
Forcing a New Excel Instance
When a resource-intensive task is processing, such as a complex formula, macro or query, it can cause Excel to become unresponsive. This is particularly annoying if you have multiple workbooks open, as you are forced to wait because you cannot…
How to Use FILTER With Wildcards
Excel’s FILTER function filters a set of data based on defined criteria. However, it doesn’t allow for partial matches that use wildcards. What are the wildcard characters? One workaround is to use FILTER in conjunction with ISNUMBER and SEARCH in…
End of content
End of content