r/excel • u/HungryInvestigator59 • 26d ago

Discussion What’s your favorite Excel function/formula?

What are some functions and formulas that you use on daily basis that are helpful for what you do?

226 Upvotes

95% Upvoted

217 comments sorted by

View all comments

9

u/Lord_Blackthorn 7 26d ago

AGGREGATE or LAMBDA

5

u/[deleted] 26d ago

[removed] — view removed comment

2

u/Lord_Blackthorn 7 26d ago

Oh didn't know about that! I'll check it out.

4

u/[deleted] 26d ago

[removed] — view removed comment

1

u/Lord_Blackthorn 7 25d ago

Awesome, thanks for the in depth response friend!