Microsoft Excel Tips and Tricks
In this Microsoft Excel video tutorial I demonstrate how to spill non-spillable functions. Aggregate functions such as SUM, AVERAGE, MIN, MAX, COUNT and MEDIAN don’t spill by default – to make them spill you need to use BYROW and BYCOL.
Credit Chester Tugwell