Scans through an array to generate intermediate values by applying a LAMBDA function to each entry. It yields an array containing the intermediate values produced at every individual step.
The SCAN function in Excel is a powerful tool for performing cumulative calculations across a range of values. It applies a specified Lambda function to an array, returning an array of intermediate results, which makes it particularly useful for analyzing data trends and creating running totals.