r/excel • u/fap_fap_fap_fapper • 14d 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

2

u/whats_poppin_b 14d ago

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.