Help With Sequence

Copper Contributor

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.

1 Reply


= LET(
    n, ROWS(calldata),
    k, SEQUENCE(n),
    b, 1+QUOTIENT(k-1,17),