Microsoft is about to release a new "Spill" feature for Excel. At time of post, this not available in the current version, but insiders can use it. Is there an "easy" (non-vba o...

I'm using the new Dynamic (ie Spill) formulas in Excel. I want a dynamic array that is the accumulation or running total of another dynamic array. Let's assume I have the following dynamic data in...

I need to create a running product from a column of numbers (I could use a row, but a column is easier to demonstrate here.) The input might be any arbitrary array. In fact, in the application wher...

Before Excel introduced spill ranges, before the “@” operator, one could ‘cast’ a range into a single value with “0+” (numeric values) or “""&” (strings). But “@” isn’t quite the same. Assume ...