I have two sets of data - Set 1 data is in Columns A-F. Set 2 data is in Columns H-M. Data is not in ascending order. In addition, Set 1 may have 100,000 rows, and Set 2 may have 50,000 rows.
I would like the VBA code to take the first row of Set 2 and compare it to all 100,000 rows in Set 1, and list the set of numbers from Set 1 that has the highest amount of matching numbers. Then go to second row of Set 2 and go through the same process, all the way down to Row 50,000 of Set 2. The output should be in Column O-U. In the event there are multiple rows of numbers from Set 1 that have an equal amount of matching numbers, it would be great if there is a way to show all of them.
Thanks in advance for any help in this matter.
I would like the VBA code to take the first row of Set 2 and compare it to all 100,000 rows in Set 1, and list the set of numbers from Set 1 that has the highest amount of matching numbers. Then go to second row of Set 2 and go through the same process, all the way down to Row 50,000 of Set 2. The output should be in Column O-U. In the event there are multiple rows of numbers from Set 1 that have an equal amount of matching numbers, it would be great if there is a way to show all of them.
Thanks in advance for any help in this matter.
