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).
[TABLE="width: 500"]
<tbody>[TR]
[TD]Column 1[/TD]
[TD]Column2[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]11[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]12[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]13[/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD]10[/TD]
[/TR]
</tbody>[/TABLE]
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).
[TABLE="width: 500"]
<tbody>[TR]
[TD]Column 1[/TD]
[TD]Column2[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]11[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]12[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]13[/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD]10[/TD]
[/TR]
</tbody>[/TABLE]
Thanks!