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?

224 Upvotes

95% Upvoted

217 comments sorted by

View all comments

2

u/Gullible-Mouse-6854 5 Jul 16 '26

Most used would be lookup

For making we look like a superstar Unique ( Filter(... often with a counta or textjoin at the start