81% OFF online library of tutorials for mastering Google Sheets

One time purchase $199



Scans an array and produces intermediate values by application of a LAMBDA function to each value. Returns an array of the intermediate values obtained at each step.

How To Use in Sheets

SCAN(initial_value, array_or_range, LAMBDA)

External Links

0Better Sheets Tutorials

No videos featuring this formula, yet. Stay tuned! In the mean time check out blogs below, and more formulas here at Better Sheets.