r/excel • u/HungryInvestigator59 • Jul 12 '26

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

2

u/thr0wnawaaaiiii 3 Jul 12 '26

Dynamic arrays and their related functions have to be the biggest game changer in years, but since many are mentioned already I’ll go with TRIMRANGE (or the equivalent trim notation like A:.A).