• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Eliminate row by macro

avnitoto

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

Attachments

  • ELIMINATE ROWS BY MACRO.xlsx
    12.6 KB · Views: 8
avnitoto
My sample ... which gives (of course) other result.
You could compare it with Yours.
Press [ Do It ]-button to see it.
 

Attachments

  • ELIMINATE ROWS BY MACRO.xlsb
    23.8 KB · Views: 8
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​
 
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

ANSWER (in Sample)
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


ANOTHER ANSWER (Explained below)
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
 
avnitoto
Just curiosity,
to whom did You answer?
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
Just curiosity,
to whom did You answer?
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 saw your correct (answer) reply later

(Before your answer I saw p45cals (answer) reply and he asked me about row 16 and 17, and I tried to Explain to p45cals in another way)

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

  • ELIMINATE ROWS BY MACRO.xlsx
    17.6 KB · Views: 6
Last edited:
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.
 
Back
Top