The SCAN function lives in a single cell and spills the results down the column, ensuring my totals are always structurally ...
Discover how the SCO ETF offers leveraged short exposure to WTI crude oil. Learn why it's for short-term traders only.
If you decide to spill the results, you can then use the spilled range operator (#) to perform a calculation on the spilled ...