Dec 18 2022 10:55 AM
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.
Dec 18 2022 11:38 AM
= LET(
n, ROWS(calldata),
k, SEQUENCE(n),
b, 1+QUOTIENT(k-1,17),
"CALL"&b
)