So I have this table, my goal is to remove the ones that are bold. The logic is to remove the rows which contain additional FALSE value, so I would end up with a FALSE, TRUE, FALSE, TRUE row.
<tbody>
</tbody>
Why?
I am scraping a site which has this annoying little html gimmick where the table is actually in a list format so when I paste it into Excel it looks like this, in the second column I am using the formula ISNUMBER:
<tbody>
</tbody>
I want the bold lines to be gone, so I would end up with a company name and a value.
I have been trying but couldn't come up with a real solution, I am also open to a VBA approach!
Thanks in advance!
False |
True |
False |
False |
False |
True |
<tbody>
</tbody>
Why?
I am scraping a site which has this annoying little html gimmick where the table is actually in a list format so when I paste it into Excel it looks like this, in the second column I am using the formula ISNUMBER:
Apple | FALSE |
2.07 | TRUE |
Microsoft | FALSE |
USA | FALSE |
IT | FALSE |
1.42 | TRUE |
<tbody>
</tbody>
I want the bold lines to be gone, so I would end up with a company name and a value.
I have been trying but couldn't come up with a real solution, I am also open to a VBA approach!
Thanks in advance!
Last edited: