Excel's Let() function
Let's follow up with the Map() function and talk about the Let() function in Excel (Office 365). The Let() function
Excel
7 articles
Excel's Map() function
Numerous programming languages have a map() function, and they all do the same thing. The Map() function applies a function
Excel's Dynamic Arrays (Part 4)
A simple dashboard We are leading up to create a simple dashboard, but we still need to cover a couple
Excel's Dynamic Arrays (Part 3)
Sequence() Syntax The Sequence() function in Office 365 creates an array of sequential numbers. The syntax is pretty easy: =SEQUENCE(
Excel's Dynamic Arrays (Part 2)
Filter() (This is for Daniel, who needs help with his Excel...) The filter() function is mighty. I'll try to explain
Excel's Dynamic Arrays (Part 1)
Introduction (This is for Daniel, who needs help with his Excel...) A couple of years ago, Microsoft introduced dynamic arrays
Let(), Xlookup() & Offset()
You need to pull a value (in this case, Hours) from a data dump for given Names. It is easy