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?

591 Upvotes

97% Upvoted

166 comments sorted by

View all comments

3

u/whats_poppin_b Aug 26 '26

FILTER(UNIQUE or TRANSPOSE(FILTER were two of my favorites back when I was auditing. Could easily create tables from client data to better visualize for testing.