Hi,
In Columns O & P I have values like below:
<colgroup><col><col></colgroup><tbody>
</tbody>
I need a Marco to find and delete the whole row , if the same values exists in both columns.
For example: R1178634 exists in column O and on a different row column P. I want to delete the whole rows.
Delete row 4 in Columns O
and Delete row 6 in Columns P as value R1178634 exists in both columns.
Thanks
In Columns O & P I have values like below:
0 | R1177092 |
0 | R1177093 |
0 | R1177227 |
R1178634 | R1178511 |
0 | R1178185 |
0 | R1178634 |
R1179555 | 0 |
<colgroup><col><col></colgroup><tbody>
</tbody>
I need a Marco to find and delete the whole row , if the same values exists in both columns.
For example: R1178634 exists in column O and on a different row column P. I want to delete the whole rows.
Delete row 4 in Columns O
and Delete row 6 in Columns P as value R1178634 exists in both columns.
Thanks