Hello,
I have a Column with 1, 2 and 3. The number of 1s, 2s and 3s can vary.
Also there are 6 combination Options in which they can appear, grid below.
I need to insert Rows after last 1 and last 2. If the result is only 3 Option F
below I need to proceed with the next step.
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Options[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]3[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]Yes[/TD]
[TD]Yes[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]Yes[/TD]
[TD]Yes[/TD]
[TD]No[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]Yes[/TD]
[TD]No[/TD]
[TD]No[/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD]No[/TD]
[TD]Yes[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]E[/TD]
[TD]No[/TD]
[TD]Yes[/TD]
[TD]No[/TD]
[/TR]
[TR]
[TD]F[/TD]
[TD]No[/TD]
[TD]No[/TD]
[TD]Yes[/TD]
[/TR]
</tbody>[/TABLE]
Tried using If, Then and ElseIf however it stops at the first condition if that is not met.
I have a Column with 1, 2 and 3. The number of 1s, 2s and 3s can vary.
Also there are 6 combination Options in which they can appear, grid below.
I need to insert Rows after last 1 and last 2. If the result is only 3 Option F
below I need to proceed with the next step.
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Options[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]3[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]Yes[/TD]
[TD]Yes[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]Yes[/TD]
[TD]Yes[/TD]
[TD]No[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]Yes[/TD]
[TD]No[/TD]
[TD]No[/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD]No[/TD]
[TD]Yes[/TD]
[TD]Yes[/TD]
[/TR]
[TR]
[TD]E[/TD]
[TD]No[/TD]
[TD]Yes[/TD]
[TD]No[/TD]
[/TR]
[TR]
[TD]F[/TD]
[TD]No[/TD]
[TD]No[/TD]
[TD]Yes[/TD]
[/TR]
</tbody>[/TABLE]
Tried using If, Then and ElseIf however it stops at the first condition if that is not met.
Last edited: