Help With Sequence

Question

I am trying to find a way to create a number list using sequence function. There are 17 rows that are all assigned to a specific "CALL" but I have hundreds of calls so I thought sequence might work to quickly fill the column. Ex: "CALL1" would be listed 17 times and the next 17 would have "CALL2" and so on repeating for every 17 rows in column "H".
If there is a better way to go about this please help, I can't seem to get this to work.

peterbartholomew1 · Answer

Nicole1212&nbsp;= LET(
    n, ROWS(calldata),
    k, SEQUENCE(n),
    b, 1+QUOTIENT(k-1,17),
    "CALL"&amp;b
  )

Forum Discussion

Help With Sequence

Share

Resources