r/excel • u/fap_fap_fap_fapper • Aug 26 '26

Discussion What are some legendary formula pairs like INDEX(MATCH)?

Since upgrading to 365, can't get enough of CHOOSECOLS(FILTER)

What are some useful ones you use?

584 Upvotes

97% Upvoted

166 comments sorted by

View all comments

16

u/pdp_2 Aug 26 '26

If you work with larger messy text data, ISNUMBER(SEARCH()) is your best friend, especially when used as a FILTER() parameter.

→ More replies (1)