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.
<tbody>
</tbody>
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.
Options | 1 | 2 | 3 |
A | Yes | Yes | Yes |
B | Yes | Yes | No |
C | Yes | No | No |
D | No | Yes | Yes |
E | No | Yes | No |
F | No | No | Yes |
<tbody>
</tbody>
Tried using If, Then and ElseIf however it stops at the first condition if that is not met.
Last edited: