Excel gets a host of new features in January 2026 ...
LAMBDA defines the custom logic, and SCAN moves that logic through your data range.