Filter rows containing cells with values within a range (for example <11 or >10 but <21)

[Harry Flashman]

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".

From there I can use Autofilter and select all the 1s.

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

 

[Harry Flashman]

Silly me. I figured it out.
=MIN(D2:CG2) and drag down
Then use autofilter custom and select all values less than 11.
I would still be curious if there is a specific formula that will
achieve the same effect. I tried COUNTIF but I couldn't get it to work
for me.

Harry