Compare 2 columns delete the row if match found

[pateln1594]

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]1111[/TD]
[TD]1[/TD]
[TD]4444[/TD]
[TD]2222[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]2222[/TD]
[TD]0[/TD]
[TD][/TD]
[TD]3333[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]3333[/TD]
[TD]0[/TD]
[TD]1111[/TD]
[TD]5555[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]4444[/TD]
[TD]1[/TD]
[TD]6666[/TD]
[TD]7777[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]5555[/TD]
[TD]1[/TD]
[TD][/TD]
[TD]8888[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]6666[/TD]
[TD]1[/TD]
[TD][/TD]
[TD]1010[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]7777[/TD]
[TD]0[/TD]
[TD]9999[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]8888[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]9999[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]1010[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

I am trying to compare Column A and Column C and if the number in Column C is found in Column A then delete the entire row. And results are in column D and E. Please help I can't use excel VBA I am trying to create a formula to do this.

 

[ravishankar]

In column F, insert the formula =if($A1=$C1,"x","") drag the formula to the last row with data using the plus handle at bottom right corner of cell. Filter the column for x and delete them.