karenjoy511
New Member
- Joined
- Sep 12, 2014
- Messages
- 31
I would like to know if there is a trick to doing this: What I have is a table with sequential numbers in the first column with values from a specified minimum to a specified maximum. In the second column I want to add a varying offset amount to the numbers in the first column, but when that sum exceeds the specified maximum, the numbers in column 2 should start again at the given minimum.
For instance, let's say I have an offset amount of 3, the minimum value is 8 and the maximum value is 13. The numbers in column 2 should increment up to 13 (the maximum), then drop back down to 8 (the minimum).
<tbody>
</tbody>
Thanks!
For instance, let's say I have an offset amount of 3, the minimum value is 8 and the maximum value is 13. The numbers in column 2 should increment up to 13 (the maximum), then drop back down to 8 (the minimum).
Column 1 | Column2 |
8 | 11 |
9 | 12 |
10 | 13 |
11 | 8 |
12 | 9 |
13 | 10 |
<tbody>
</tbody>
Thanks!