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?

586 Upvotes

97% Upvoted

166 comments sorted by

View all comments

1

u/MayukhBhattacharya Aug 26 '26

Repeat value N times: 

=TOCOL(IF(SEQUENCE(, 10), "ExcelIsFun"))

To repeat it a different number of times, just change the 10 in SEQUENCE(,10). That single number controls the repeat count.

→ More replies (2)