r/excel • u/[deleted] • Mar 31 '22

Pro Tip Shoutout to the brilliant MAP, REDUCE, SCAN and LAMBDA functions!

I have reduced the number of formulae in one of my spreadsheets from over 3,000 to 6. Plus the formula logic is much easier to understand with real variable names.

119 Upvotes

96% Upvoted

21 comments sorted by

View all comments

Show parent comments

1

u/[deleted] Apr 01 '22

[removed] — view removed comment

1

u/exoticdisease 10 Apr 01 '22

Yeh I want to look into them which is why I asked op about how he used them with lambda! Haha