I am trying to figure out a formula so that
for variable in cell C1 = 4 (for instance)
Input Output
1 1
2 2
3 3
4 1
5 2
6 3
7 4
8 1
9 2
10 3
11 4
12 1
and so on.
if C1 = 7 then the series would be
1,2,3,4,5,6,1,2,3,4,5,6,7,1,2,3,4,5,6,7...
any ideas on what the formula should be?
Thanks
for variable in cell C1 = 4 (for instance)
Input Output
1 1
2 2
3 3
4 1
5 2
6 3
7 4
8 1
9 2
10 3
11 4
12 1
and so on.
if C1 = 7 then the series would be
1,2,3,4,5,6,1,2,3,4,5,6,7,1,2,3,4,5,6,7...
any ideas on what the formula should be?
Thanks