SCAN Excel function

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.