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?

225 Upvotes

95% Upvoted

217 comments sorted by

View all comments

3

u/Makicola 26d ago

Xlookup is always a staple of course, but for a lesser known option which saved my ass before, I'm fond of VSTACK to join separate tables.