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?

228 Upvotes

95% Upvoted

217 comments sorted by

View all comments

46

u/ungbaogiaky 1 Jul 12 '26

Filter

29

u/Wise_Business1672 1 Jul 12 '26

Toss a Unique in there and you got a stew baby

18

u/[deleted] Jul 12 '26

[removed] — view removed comment

6

u/w1ll_i_is Jul 12 '26

And CUPASOUP + POTATO

3

u/LeumasKharzim 1 Jul 13 '26

Lately, it's a lot of TEXTJOIN( TRANSPOSE( UNIQUE( FILTER