TEXTSPLIT and BYROW were both released earlier this year. The former allows you to split a text value by a delimiter, whilst the latter applies a LAMBDA to each row and returns an array of the results. Take a look…
Want an alternative to those boring 2D images strewn across your worksheet? Consider 3D models, which are graphics that can be rotated 360° or tilted up and down. Excel has an extensive range of static and animated 3D stock models….
It’s well-known that the Excel, Word and PowerPoint ribbons vary because each program has a different use case. In Excel for desktop, however, one glaring omission is a Strikethrough button in the Home tab. Interestingly, Excel for the web does…
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…
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…
In the late nineties when I was still at primary school, I remember us having a weekly spelling test. There were 10 words the teacher would say aloud, and we would have 30 seconds to write each of them down….
End of content
End of content
