Hi everyone,
I need help with parsing out numbers which don't meet a specific set criteria..


I have attached a workbook with an example table .. the explanation below is keyed to that table. The table consists of numbers 1 to 60 across the top in row 3, B3 to BI3, these are the main numbers. 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 meet or not the criteria I have set. So lets take the number 59 for example. The column of numbers below it, in BH5 to BH22 all must meet the criteria in the corresponding cell in column BJ. So, the first set of criteria is in BJ5, which is “ =>0 < .3”. So the number in BH5 must meet the criteria in BJ5, which it does. .28 falls between the criteria =>0 and <.3. the same goes for all the rest of the numbers in that column BH6 down to BH22, and also for each of the Main numbers in Row 3 and the numbers in each of those columns.

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.... in the example I only show a couple numbers which have matches. Once completed, all of the main numbers, in row 3, 1 to 60 should have matches in their respective columns.

Then based on the number I have set in BK3, which is set to 4 in the example table, the matching number, and using the attached table, if a main number in row 3 has 4 or more matches, then it will be returned in a list in column BL, starting in BL4 down. 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.


I originally posted this problem on Chandoo. But only got 1 reply, no resolution. I informed in my post that I was also posting here.

Thank you for your time and help.

Attached Files

Range Example.xlsx (25.8 KB, 6 views)