Compare 2 columns delete the row if match found

[pateln1594]

	A	B	C	D	E
1	1111	1	4444	2222	0
2	2222	0		3333	0
3	3333	0	1111	5555	1
4	4444	1	6666	7777	0
5	5555	1		8888	1
6	6666	1		1010	0
7	7777	0	9999
8	8888	1
9	9999	0
10	1010	0

<tbody>
</tbody>

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.