Tech expert ThioJoe demonstrates 10 hidden Excel features that can make working with spreadsheets easier.
LAMBDA defines the custom logic, and SCAN moves that logic through your data range.