Hi,
I want to copy all the cells in column A;C. Requirement is that A is not blank, and either B or C is not blank.
For instance, I copy the following list:
Then the output should be:
Removing the row of test 8 & test 12, because both have B & C blank. Using Excel 2013.
I want to copy all the cells in column A;C. Requirement is that A is not blank, and either B or C is not blank.
For instance, I copy the following list:
Code:
[TABLE="width: 192"]
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]test1[/TD]
[TD="width: 64, align: right"]10[/TD]
[TD="width: 64, align: right"]10[/TD]
[/TR]
[TR]
[TD]test2[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]20[/TD]
[/TR]
[TR]
[TD]test3[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]30[/TD]
[/TR]
[TR]
[TD]test4[/TD]
[TD="align: right"]40[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]test5[/TD]
[TD="align: right"]50[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]test6[/TD]
[TD="align: right"]60[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]test7[/TD]
[TD="align: right"]70[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl63"]test8[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[/TR]
[TR]
[TD]test9[/TD]
[TD][/TD]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TD]test10[/TD]
[TD][/TD]
[TD="align: right"]20[/TD]
[/TR]
[TR]
[TD]test11[/TD]
[TD][/TD]
[TD="align: right"]30[/TD]
[/TR]
[TR]
[TD="class: xl63"]test12[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[/TR]
[TR]
[TD]test13[/TD]
[TD="align: right"]30[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Then the output should be:
Code:
[TABLE="width: 192"]
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]test1[/TD]
[TD="width: 64, align: right"]10[/TD]
[TD="width: 64, align: right"]10[/TD]
[/TR]
[TR]
[TD]test2[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]20[/TD]
[/TR]
[TR]
[TD]test3[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]30[/TD]
[/TR]
[TR]
[TD]test4[/TD]
[TD="align: right"]40[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]test5[/TD]
[TD="align: right"]50[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]test6[/TD]
[TD="align: right"]60[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]test7[/TD]
[TD="align: right"]70[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]test9[/TD]
[TD][/TD]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TD]test10[/TD]
[TD][/TD]
[TD="align: right"]20[/TD]
[/TR]
[TR]
[TD]test11[/TD]
[TD][/TD]
[TD="align: right"]30[/TD]
[/TR]
[TR]
[TD]test13[/TD]
[TD="align: right"]30[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Removing the row of test 8 & test 12, because both have B & C blank. Using Excel 2013.