- December 2024
- November 2024
- October 2024
- September 2024
- August 2024
- July 2024
- June 2024
- May 2024
- April 2024
- March 2024
- February 2024
- January 2024
- December 2023
- November 2023
- October 2023
- September 2023
- August 2023
- July 2023
- June 2023
- May 2023
- April 2023
- March 2023
- February 2023
- December 2022
- November 2022
- October 2022
- September 2022
- August 2022
- July 2022
- June 2022
- May 2022
- April 2022
- March 2022
- February 2022
- January 2022
- December 2021
- November 2021
- October 2021
- September 2021
- August 2021
- July 2021
- June 2021
- April 2021
- March 2021
- February 2021
- January 2021
- December 2020
- November 2020
- October 2020
- September 2020
- July 2020
| ID | Title 1 | Title 2 |
|---|---|---|
| Sample #1 | Row 1, Content 1 | Row 1, Content 2 |
| Sample #2 | Row 2, Content 1 | Row 2, Content 2 |
| Sample #3 | Row 3, Content 1 | Row 3, Content 2 |
A solution to the annoying problem with the HYPERLINK function
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…
Happy Summer Solstice!
Happy Summer Solstice! ☀️ It’s officially the longest day of the year in the Northern Hemisphere. The UK’s summer solstice occurred at 15:57 BST, marking the point at which the astronomical summer begins. Now we gradually work our way towards…
The HYPERLINK function has an annoying problem
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…
Apple Vision Pro — an expensive pair of ski goggles
Apple Vision Pro won’t suffer from the ill-fated collapse that 3D TVs did. This time there’s trajectory. We know exactly where we’re headed, although emerging from the formative stages will take a while. The bulky and cumbersome nature of this…
Taste the Sheets
In recent years, it’s become customary for multi-billion dollar corporations and conglomerates to rainbow-wash their social media accounts in support of June’s Pride Month. This trend initially started as a laudable show of solidarity towards marginalised groups, but many people…
Excel gaffe sees party elect wrong leader
Ah, it’s all Excel’s fault again, isn’t it? Austria’s Social Democratic Party ran an election over the weekend to determine its new leader. After nearly 600 members cast their votes, it was announced that Burgenland governor Hans Peter Doskozil had…
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…
Happy Summer Solstice! ☀️ It’s officially the longest day of the year in the Northern Hemisphere. The UK’s summer solstice occurred at 15:57 BST, marking the point at which the astronomical summer begins. Now we gradually work our way towards…
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…
Apple Vision Pro won’t suffer from the ill-fated collapse that 3D TVs did. This time there’s trajectory. We know exactly where we’re headed, although emerging from the formative stages will take a while. The bulky and cumbersome nature of this…
In recent years, it’s become customary for multi-billion dollar corporations and conglomerates to rainbow-wash their social media accounts in support of June’s Pride Month. This trend initially started as a laudable show of solidarity towards marginalised groups, but many people…
Ah, it’s all Excel’s fault again, isn’t it? Austria’s Social Democratic Party ran an election over the weekend to determine its new leader. After nearly 600 members cast their votes, it was announced that Burgenland governor Hans Peter Doskozil had…