SCAN()

Description

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 yet. Stay tuned!