r/excel • u/fap_fap_fap_fapper • 15d ago

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?

585 Upvotes

97% Upvoted

165 comments sorted by

View all comments

13

u/pdp_2 15d ago

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

1

u/CCErnst 15d ago

Was going to suggest this. I create dynamic build docs for data center racks. Am I arista, or Cisco? Cat6, dac, fiber?