Forum Discussion
Nicole1212
Dec 18, 2022Copper Contributor
Help With Sequence
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 t...
PeterBartholomew1
Dec 18, 2022Silver Contributor
= LET(
n, ROWS(calldata),
k, SEQUENCE(n),
b, 1+QUOTIENT(k-1,17),
"CALL"&b
)