Dynamic list based on condition

[Mandark]

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.

 

[legento]

Hi,

Using a pivot table might work... you would have to adjust the filters on the table to show only true. And you would have to refresh the data after any change to update the table.

 

[Mandark]

Thanks, but I believe it could be done using normal or array formula.