Determining Consecutive Sales Trend with Formula

There is an Excel file that teaches how to perform the Determining Consecutive Sales Trend with Formula operation.

Excel Powered Determining Consecutive Sales Trend with Formula

It automatically detects consecutive upward or downward trends in daily sales data. Additionally, MAP and LAMBDA functions are utilized to create a four-day sliding window for each row. Thus, sales moving in the same direction for three consecutive days are labeled as Up or Down accordingly. However, when insufficient historical data is available, the result is returned as Neutral. Therefore, this file performs momentum-based trend analysis with a single dynamic array formula.

Hope it is useful.