Practical use for Excel’s EXPAND function | VSTACK mystery solved | Dynamic Arrays
In my previous video I uncovered something odd about VSTACK. Turns out, VSTACK is doing what it’s supposed to do. I show that in the video. And that leads to something fascinating: EXPAND. The EXPAND function on its own seems strange and pointless. However, in this situation EXPAND saves the day in a practical example. […]