deleting rows containing 2 to 4 numbers

[excelNewbie22]

i have a file with thousands of lines, each line have 4 cells, each cell have 1 number (no empty lines, starting with a1)
i need a macro which can delete any line/row who doesn't contain the one of the 4 numbers i will set each time
for example: each row who doesn't have either 5 or 4 or 3 or 2 will be deleted, and sometimes the range can be only 2 or 3 numbers (like 5, 4 and 6 or 2 and 1)
can anyone help me out?

1234
	A	B	C	D
1	6	6	2	5
2	6	1	4	4
3	6	5	5	6
4	2	2	1	5
5	4	2	2	1
6	1	6	1	1
7	2	2	1	2
8	2	2	2	5
9	3	5	1	1
10	6	1	7	1
11	4	2	1	1
12	1	6	6	1
13	1	3	1	6
14	3	2	4	5
15	3	4	6	2
16	6	5	1	1
17	5	1	5	4
18	1	6	2	6
19	4	1	6	2
20	2	1	3	3
21	6	4	4	1
22	1	3	2	4
1234

 

[excelNewbie22]

?

 

[excelNewbie22]

anyone?

please tell me if it's ok to bump the question up or am i allowed to ask again in a few days?

 

[Joe4]

please tell me if it's ok to bump the question up or am i allowed to ask again in a few days?

We usually advise waiting for 24 hours to make the first bump, and bump once a day after that.

Very curious, you seem to have a lot of similiar questions with minor twists each time.
Is this some sort of school project/assignment?

Since you already had a few of them answered, you may want to study those techniques, and see if you can come up with your own solutions, and if you are unable, post what you attempted.

 

[excelNewbie22]

you can say it's a private project of mine,

already tried to, with Similar threads found in this forum here, and in google,
tried to edit/modified them but with no success
for this moment, i only left with 4 or 5 of questions (maybe i'll slow down asking them)
in the meantime, i'll still glad to get help with the one above

and in any case:
do you have in mind some place online (for free) which i can learned macro/formulas for excell EASY way?

 

[Joe4]

do you have in mind some place online (for free) which i can learned macro/formulas for excell EASY way?

There are TONS of free tutorials and YouYube videos that can be found with some simple Google searches.

MrExcel also sells many books on a wide variety of topics, including VBA (found here: Products), and hundeds of videos, which can be found here: MrExcel Excel Videos

 

[Joe4]

For your current problem, one simple way (that does not require you to know VBA) would be to do something like the answer for this first question you submitted: finding duplicate rows (multiple cells)

You can use a Helper Column which adds up four COUNTIF formulas (count the number of 2s + count the number of 3s + count the number of 4s + count the number of 5s).
Then you can delete any row where that SUM is 0.

 

[excelNewbie22]

tnx
manage to do it,
but the process is longer and since i need every time to check and replace numbers and run several tests i'll try working out a macro
thank you!

 

[Joe4]

If you prefer automated/VBA solutions, that is a good thing to put in your initial post, so people have a better idea of exactly what you are looking for.

You may be able to do something like what Rick Rothstein showed you back here: deleting identical numbers