Higher-order functions se array-level calculations.
“MAP, REDUCE, SCAN, BYROW & BYCOL” is part of Level 3: Advanced Excel — Dynamic Arrays, Power Query, DAX & VBA (20 Lessons). Free preview lessons are open to everyone; the remaining lessons are for enrolled learners.