Hello Excel’ers,
I come to you with another problem.. I am posting in VBA board because I have tried to do this with regular formulas and have failed miserably..
I have attached a workbook with an example table.. The table consists of numbers 1 to 60 across the top in row 3, B3 to BI3. Then from B4 to BI22 is a bunch of numbers of various values. These numbers are results of other factors and formulas and are constantly changing.
In column BJ, BJ5 to BJ22 I have matching criteria for each row. Each of the numbers in each row must either match or not the criteria I have set. So lets take the number 59 for example. Starting in row 5, the criteria in BJ5, =>0 < .3, this is the criteria each number in Row 5 must meet, I guess either making it True if it matches or False if it doesn’t. In the attached example table, the number in BH5 is .28 and falls within the set criteria, so it is true. This is the same for each row..
I have highlighted in yellow the matches for numbers 57, 58, 59 and 60 as an example. 57 has 4 matches, 58 has 14 matches, 59 has 5 and 60 has 3. But this is how all the numbers 1 thru 60 should work. As an example, I have completed row 5 also. I don't need the numbers highlighted in the final version.. but hey, if you can do it easily then why not....
Then based on the number I have set in BK3, the matching number, and using the attached table, if a number has 4 or more matches, then it will be returned in a list in column BL, starting in BL4 down, depending on how many matches of 4 or greater there are. If a number has less then 4 then it won’t be returned, 60 has 3 so it won’t get returned in the list. If I change the matching number to 3, then 57, 58 59 and 60 would be returned. If I changed the matching number to 13, then only 58 would be returned since it is the only number (in the example) with 13 or more matching numbers. Keep in mind, in a completed version, all 60 numbers would be in play as they all would have matches of different quantities.
I hope this makes sense.. please let me know if you have questions.
Thank you for your time and help.
Dave.
I come to you with another problem.. I am posting in VBA board because I have tried to do this with regular formulas and have failed miserably..
I have attached a workbook with an example table.. The table consists of numbers 1 to 60 across the top in row 3, B3 to BI3. Then from B4 to BI22 is a bunch of numbers of various values. These numbers are results of other factors and formulas and are constantly changing.
In column BJ, BJ5 to BJ22 I have matching criteria for each row. Each of the numbers in each row must either match or not the criteria I have set. So lets take the number 59 for example. Starting in row 5, the criteria in BJ5, =>0 < .3, this is the criteria each number in Row 5 must meet, I guess either making it True if it matches or False if it doesn’t. In the attached example table, the number in BH5 is .28 and falls within the set criteria, so it is true. This is the same for each row..
I have highlighted in yellow the matches for numbers 57, 58, 59 and 60 as an example. 57 has 4 matches, 58 has 14 matches, 59 has 5 and 60 has 3. But this is how all the numbers 1 thru 60 should work. As an example, I have completed row 5 also. I don't need the numbers highlighted in the final version.. but hey, if you can do it easily then why not....
Then based on the number I have set in BK3, the matching number, and using the attached table, if a number has 4 or more matches, then it will be returned in a list in column BL, starting in BL4 down, depending on how many matches of 4 or greater there are. If a number has less then 4 then it won’t be returned, 60 has 3 so it won’t get returned in the list. If I change the matching number to 3, then 57, 58 59 and 60 would be returned. If I changed the matching number to 13, then only 58 would be returned since it is the only number (in the example) with 13 or more matching numbers. Keep in mind, in a completed version, all 60 numbers would be in play as they all would have matches of different quantities.
I hope this makes sense.. please let me know if you have questions.
Thank you for your time and help.
Dave.