Hello,
I want VBA help to find remaining list of numbers inside the cycle list, which is a bit tricky task here below I have tried to explain if it is not clear please ask the question.
Step1-I got main list of numbers in the cells M2:AF2, I want this list to be checked with range B4:J4 numbers and after finding the remaining numbers, list them in range M4:AF4 under each corresponding number of the main list.
Step2-which complicate the situation, now main list must be checked (with 2 rows) with range B4:J4 numbers and after finding the remaining numbers, list them in range M5:AF5 under each corresponding number of the main list.
Step3-it must search remaining numbers till main list number are finished...when none number is left...END the search. (In this example in the range B9:J9 all numbers are over)
Step4-then start new remaining lists calculation, and continues the same task for next rows till end of the list find in the columns B:J
About these example results sample image is attached.
Kind Regards
Moti
I want VBA help to find remaining list of numbers inside the cycle list, which is a bit tricky task here below I have tried to explain if it is not clear please ask the question.
Step1-I got main list of numbers in the cells M2:AF2, I want this list to be checked with range B4:J4 numbers and after finding the remaining numbers, list them in range M4:AF4 under each corresponding number of the main list.
Step2-which complicate the situation, now main list must be checked (with 2 rows) with range B4:J4 numbers and after finding the remaining numbers, list them in range M5:AF5 under each corresponding number of the main list.
Step3-it must search remaining numbers till main list number are finished...when none number is left...END the search. (In this example in the range B9:J9 all numbers are over)
Step4-then start new remaining lists calculation, and continues the same task for next rows till end of the list find in the columns B:J
Unique | |||||||||||||||||||||||||||||||
n1 | n2 | n3 | n4 | n5 | n6 | n7 | n8 | n9 | Number List | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | ||
1 | 3 | 5 | 6 | 10 | 15 | 17 | 18 | 19 | 2 | 4 | 7 | 8 | 9 | 11 | 12 | 13 | 14 | 16 | 20 | ||||||||||||
3 | 5 | 8 | 9 | 11 | 13 | 16 | 19 | 20 | 2 | 4 | 7 | 12 | 14 | ||||||||||||||||||
2 | 4 | 5 | 6 | 7 | 12 | 14 | |||||||||||||||||||||||||
8 | 9 | 10 | 15 | 16 | 19 | 7 | 12 | 14 | |||||||||||||||||||||||
7 | 9 | 15 | 18 | 19 | 20 | 12 | 14 | ||||||||||||||||||||||||
1 | 7 | 12 | 14 | 19 | |||||||||||||||||||||||||||
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | ||||||||||||
7 | 10 | 17 | 4 | 5 | 6 | 8 | 9 | 11 | 12 | 13 | 14 | 15 | 16 | 18 | 19 | 20 | |||||||||||||||
4 | 8 | 12 | 14 | 15 | 17 | 19 | 20 | 5 | 6 | 9 | 11 | 13 | 16 | 18 | |||||||||||||||||
1 | 4 | 5 | 6 | 9 | 11 | 13 | 16 | 18 | |||||||||||||||||||||||
16 | 20 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 17 | 18 | 19 | ||||||||||||
9 | 10 | 11 | 13 | 14 | 17 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 12 | 15 | 18 | 19 |
About these example results sample image is attached.
Kind Regards
Moti