Column B consists of Brand names (each brand has numerous products)
Column C consists of Product names (over 500 products)
Coumns D to CG (row 1) consist of months going back a few years.
The data from D2:CG539 consists of the rank of each brand for each
month.
I would like to filter my rows so that I can view only the products
that have ever ranked in the top 10.
I already have a couple of formulas that allow me to filter my data.

Example 1:
If I want to know the highest rank ever achieved by a product I use
this formula: =MIN(D2:CG2) and then drag it down. Now I can use
autofilter and see which products have ever achieved rank 1, or rank 2
etc.

Example 2:
I am able to filter my products (for example a particular competive
set) by using COUNTIF.
On another sheet I label a range of data (the names of the competive
set) "Match".
Then in column A I use the formula =COUNTIF(Match,D2) and then drag it
down.
This puts a 1 next to any product that is in my range "match".

I am looking for a formula that will perform a similar task, but
filter based on the values along each row falling within a range,
rather than the product name or specific rank.

I would be very appreciative of any suggestions. Thank you.
Harry