Hi,
I have a table with 1000 records. Only approx. 10% of them however have some TRUE condition.
[TABLE="width: 200"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Condition[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]TRUE[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]FALSE[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]FALSE[/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD]FALSE[/TD]
[/TR]
[TR]
[TD]E[/TD]
[TD]FALSE[/TD]
[/TR]
[TR]
[TD]F[/TD]
[TD]TRUE[/TD]
[/TR]
[TR]
[TD]...[/TD]
[TD]...[/TD]
[/TR]
</tbody>[/TABLE]
I would like to create a table on another sheet that shows list of names, but only for those rows, where the condition is TRUE. Also, I don't want to have any blank rows. So just a nice list of approx. 100 rows.
Is that possible?
Thanks.
I have a table with 1000 records. Only approx. 10% of them however have some TRUE condition.
[TABLE="width: 200"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Condition[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]TRUE[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]FALSE[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]FALSE[/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD]FALSE[/TD]
[/TR]
[TR]
[TD]E[/TD]
[TD]FALSE[/TD]
[/TR]
[TR]
[TD]F[/TD]
[TD]TRUE[/TD]
[/TR]
[TR]
[TD]...[/TD]
[TD]...[/TD]
[/TR]
</tbody>[/TABLE]
I would like to create a table on another sheet that shows list of names, but only for those rows, where the condition is TRUE. Also, I don't want to have any blank rows. So just a nice list of approx. 100 rows.
Is that possible?
Thanks.