New answers tagged microsoft-excel
1
vote
How to repeat a cell a set number of times in Excel?
Here's my solution without thunks or TEXTSPLIT.
=LAMBDA(in,
LET(
dupl, LAMBDA(str, mult, str & T(SEQUENCE(mult))),
DROP(
REDUCE("", SEQUENCE(ROWS(in)),
...
Top 50 recent answers are included
Related Tags
microsoft-excel × 86google-sheets × 67
formulas × 18
google-apps-script × 6
excel-online × 6
google-sheets-arrayformula × 5
google-docs × 4
gmail × 3
google-drive × 3
google-sheets-query × 3
conditional-formatting × 3
trello × 2
google-forms × 2
google-sheets-charts × 2
vlookup × 2
regex × 2
date × 2
google-sheets-cell-format × 2
website × 2
pivot-table × 2
cognito-forms × 1
google × 1
keyboard-shortcuts × 1
importrange × 1
commcare × 1