LAMBDA defines the custom logic, and SCAN moves that logic through your data range.
Discover 17 new Excel features and functions for 2026, so you track edits and data faster. Including auto-refreshing pivots ...
Results that may be inaccessible to you are currently showing.
Hide inaccessible results
Feedback