macro deleting 3 out of 4 in any combo

[excelNewbie22]

hi

how can i delete all rows containing 3 out of 4 predefined numbers ?

for example, predefined numbers are:
1 2 3 4
and i want to delete any row containing any combo of 3 out of these 4 ?
like:
1235 or 4128 or 6341 and so on
(without repeats of one the numbers like 8332=keep)

1 2 3 7 delete
5 6 2 7 keep
5 2 1 3 delete
6 7 2 4 keep
1 3 5 2 delete
4 5 2 3 delete
2 2 1 5 keep
1 3 5 5 keep
8 3 3 2 keep

sheet1
	A	B	C	D	E
1	1	2	3	7	delete
2	5	6	2	7	keep
3	5	2	1	3	delete
4	6	7	2	4	keep
5	1	3	5	2	delete
6	4	5	2	3	delete
7	2	2	1	5	keep
8	1	3	5	5	keep
9	8	3	3	2	keep
sheet1

 

[excelNewbie22]

BSALV:
check your what you paste in g8 for 1234 aka column e and h17 for 5543 aka column f

Rick Rothstein:
p-e-r-f-e-c-t-!-!-!
?