Hi,
I have a table with 1000 records. Only approx. 10% of them however have some TRUE condition.
<tbody>
</tbody>
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.
Name | Condition |
A | TRUE |
B | FALSE |
C | FALSE |
D | FALSE |
E | FALSE |
F | TRUE |
... | ... |
<tbody>
</tbody>
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.