Is Excel for the web’s calculation engine more advanced than its desktop counterpart? The other day, I identified a gaping problem with the HYPERLINK function. After trying to return a table-based column of URLs as a dynamic array, its friendly_name…
Wouldn’t it be great if the HYPERLINK function was fully compatible with dynamic arrays? Here’s the function’s syntax: I have a table called tblWebsites featuring three websites, each with its name and URL. In D2, if I were to reference…
As a rule of thumb, referencing a whole column in Excel isn’t considered good practice. It’s better to include only the cells you need in a range. And it’s even better to use tables so you’re working with structured references….
Excel’s FILTER function sieves a set of data based on defined criteria. However, it doesn’t allow the use of wildcards for partial matches. What are the wildcard characters? * (asterisk) — represents any number of characters. ? (question mark) —…
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…
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…
End of content
End of content
