Eliminate row by macro

avnitoto

New Member
How can I eliminate row by a macro
Question is at the attached file
Thanks

Attachments

• 12.6 KB Views: 8

vletm

Excel Ninja
avnitoto
My sample ... which gives (of course) other result.
You could compare it with Yours.
Press [ Do It ]-button to see it.

Attachments

• 23.8 KB Views: 8

p45cal

Well-Known Member
In your sample file, in row 16 you have: "eliminated by row 32(five values are same)".
Row 17 also has five values the same, so why not show "eliminated by row 17(five values are same)"?

Row 16:
 1​ 2​ 3​ 4​ 6​ 8​
Row 17:
 1​ 2​ 3​ 4​ 6​ 9​

avnitoto

New Member
hi,
I think you can't understand

suppose you find (answer in the box in my sample )compare 84 rows one with each answer in the box if 4 or less or no one same will be written in the box it wil be the answer that I want

1 2 3 4 6 7
1 2 3 5 8 9
1 2 4 5 6 8
1 2 5 6 7 9
1 3 4 5 6 9
1 3 4 5 7 8
1 3 6 7 8 9
2 3 4 6 8 9
2 3 5 6 7 8
2 4 5 7 8 9

1- 1 2 3 4 5 6
8- 1 2 3 4 7 8
15- 1 2 3 5 7 9
19- 1 2 3 6 8 9
--
--
--and so on

QUESTION 84 rows will be compare one with each other if 4 values or less or no one match will be written in the Answer box it wil be the answer that I want

This Time lets start with first row (Take First Row BASE, it MUST be writen to answer box)

I try to explain below I think you will understand how to do

1- 1 2 3 4 5 6 ++++ (WRITE TO ANSWER BOX)
2- 1 2 3 4 5 7 ------ compare with row 1, five value are match, eliminated by row 1
3- 1 2 3 4 5 8 ------ compare with row 1, five value are match, eliminated by row 1
4- 1 2 3 4 5 9 ------ compare with row 1, five value are match, eliminated by row 1
5- 1 2 3 4 6 7 ------ compare with row 1, five value are match, eliminated by row 1
6- 1 2 3 4 6 8 ------ compare with row 1, five value are match, eliminated by row 1
7- 1 2 3 4 6 9 ------ compare with row 1, five value are match, eliminated by row 1
8- 1 2 3 4 7 8 ++++ (WRITE TO ANSWER BOX) compare with row 1, FOUR value are match
9- 1 2 3 4 7 9 ------ compare with row 1 and row 8, five value are match, eliminated by row 8
10- 1 2 3 4 8 9 ------ compare with row 1 and row 8, five value are match, eliminated by row 8
11- 1 2 3 5 6 7 ------ compare with row 1 and row 8, five value are match, eliminated by row 1
12- 1 2 3 5 6 8 ------ compare with row 1 and row 8, five value are match, eliminated by row 1
13- 1 2 3 5 6 9 ------ compare with row 1 and row 8, five value are match, eliminated by row 1
14 -1 2 3 5 7 8 ------ compare with row 1 and row 8, five value are match, eliminated by row 8
15- 1 2 3 5 7 9 ++++ (WRITE TO ANSWER BOX) compare with row 1 and row 8, FOUR value are match
16- 1 2 3 5 8 9 ------ compare with row 1 and row 8 and row 15, five value are match, eliminated by row 15
17- 1 2 3 6 7 8 ------ compare with row 1 and row 8, and row 15 five value are match, eliminated by row 8
18- 1 2 3 6 7 9 ------ compare with row 1 and row 8, and row 15 five value are match, eliminated by row 15
19- 1 2 3 6 8 9 ++++ (WRITE TO ANSWER BOX) compare with row 1 and row 8 and row 15, FOUR value are match
20- 1 2 3 7 8 9 ------ compare with row 1 and row 8, and row 15 and row 19 five value are match, eliminated by row 19
21- 1 2 4 5 6 7 ------ compare with row 1 and row 8, and row 15 and row 19 five value are match, eliminated by row 1
22- 1 2 4 5 6 8 ------ compare with row 1 and row 8, and row 15 and row 19 five value are match, eliminated by row 1
23- 1 2 4 5 6 9 ------ compare with row 1 and row 8, and row 15 and row 19 five value are match, eliminated by row 1
24- 1 2 4 5 7 8 ------ compare with row 1 and row 8, and row 15 and row 19 five value are match, eliminated by row 8
25- 1 2 4 5 7 9 ------ compare with row 1 and row 8, and row 15 and row 19 five value are match, eliminated by row 15
26- 1 2 4 5 8 9 ++++ (WRITE TO ANSWER BOX) compare with row 1 and row 8 and row 15 and row 19, FOUR value are match
27- 1 2 4 6 7 8 ---
28- 1 2 4 6 7 9 ---
29- 1 2 4 6 8 9 --- AND SO ON
30- 1 2 4 7 8 9
31- 1 2 5 6 7 8
32- 1 2 5 6 7 9
33- 1 2 5 6 8 9
34- 1 2 5 7 8 9
35- 1 2 6 7 8 9
36- 1 3 4 5 6 7
37- 1 3 4 5 6 8
38- 1 3 4 5 6 9
39- 1 3 4 5 7 8
40- 1 3 4 5 7 9
41- 1 3 4 5 8 9
42- 1 3 4 6 7 8
43- 1 3 4 6 7 9
44- 1 3 4 6 8 9
45- 1 3 4 7 8 9
46- 1 3 5 6 7 8
47- 1 3 5 6 7 9
48- 1 3 5 6 8 9
49- 1 3 5 7 8 9
50- 1 3 6 7 8 9
51- 1 4 5 6 7 8
52- 1 4 5 6 7 9
53- 1 4 5 6 8 9
54- 1 4 5 7 8 9
55- 1 4 6 7 8 9
56- 1 5 6 7 8 9
57- 2 3 4 5 6 7
58- 2 3 4 5 6 8
59- 2 3 4 5 6 9
60- 2 3 4 5 7 8
61- 2 3 4 5 7 9
62- 2 3 4 5 8 9
63- 2 3 4 6 7 8
64- 2 3 4 6 7 9
65- 2 3 4 6 8 9
66- 2 3 4 7 8 9
67- 2 3 5 6 7 8
68- 2 3 5 6 7 9
69- 2 3 5 6 8 9
70- 2 3 5 7 8 9
71- 2 3 6 7 8 9
72- 2 4 5 6 7 8
73- 2 4 5 6 7 9
74- 2 4 5 6 8 9
75- 2 4 5 7 8 9
76- 2 4 6 7 8 9
77- 2 5 6 7 8 9
78- 3 4 5 6 7 8
79- 3 4 5 6 7 9
80- 3 4 5 6 8 9
81- 3 4 5 7 8 9
82- 3 4 6 7 8 9
83- 3 5 6 7 8 9
84- 4 5 6 7 8 9

vletm

Excel Ninja
avnitoto
Just curiosity,
Do You understand that,
You want only those already green marked rows to the Answer box,
and nothing else cannot be as You understand ... or how?
If You ... wrote about my reply ... then what was incorrect?

avnitoto

New Member
avnitoto
Just curiosity,
Do You understand that,
You want only those already green marked rows to the Answer box,
and nothing else cannot be as You understand ... or how?
If You ... wrote about my reply ... then what was incorrect?
THANK YOU VERY MUCH FOR YOUR SUPER MACRO

Sorry I forget to write to sample file Is it possible to do it for other worksheets when macro run doing it for all worksheets (sample file is same Just add three worksheets) the last file attached contain worksheets

Attachments

• 17.6 KB Views: 6
Last edited:

vletm

Excel Ninja
avnitoto
Hint:
If You shout 'Free Ice Cream!'
that means 'Free Ice Cream!' for everybody
- Thank You.
But it You would say it only for Your own kid
... then it would good to use name
... much economy for You.