coolzsters
New Member
- Joined
- Jul 23, 2018
- Messages
- 13
Dear all Master....
Example :
[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[/TR]
[TR]
[TD]Items[/TD]
[TD]7/6/2018[/TD]
[TD]7/7/2018[/TD]
[TD]7/8/2018[/TD]
[TD]7/9/2018[/TD]
[TD]7/10/2018[/TD]
[TD]7/11/2018[/TD]
[TD]7/12/2018[/TD]
[TD]Result[/TD]
[/TR]
[TR]
[TD]Bananas[/TD]
[TD][/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"]?[/TD]
[/TR]
[TR]
[TD]Apple[/TD]
[TD][/TD]
[TD][/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"]?[/TD]
[/TR]
[TR]
[TD]Orange[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD="align: center"]?[/TD]
[/TR]
</tbody>[/TABLE]
I really need help, i want to find a Date in result column when found first "1" variables...


Example :
[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[/TR]
[TR]
[TD]Items[/TD]
[TD]7/6/2018[/TD]
[TD]7/7/2018[/TD]
[TD]7/8/2018[/TD]
[TD]7/9/2018[/TD]
[TD]7/10/2018[/TD]
[TD]7/11/2018[/TD]
[TD]7/12/2018[/TD]
[TD]Result[/TD]
[/TR]
[TR]
[TD]Bananas[/TD]
[TD][/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"]?[/TD]
[/TR]
[TR]
[TD]Apple[/TD]
[TD][/TD]
[TD][/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: center"]?[/TD]
[/TR]
[TR]
[TD]Orange[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD="align: center"]?[/TD]
[/TR]
</tbody>[/TABLE]
I really need help, i want to find a Date in result column when found first "1" variables...


