Display all rows that fulfill a criteria

[ARJUNDSOUZA]

Dear All,

I would like to ask your help in finding out a formula that would display all rows which fulfill the criteria

Example : Cell A1 = 90% and Cell B1 = 96%

Given the data in Cell C1 to C300, I would like a formula which will filter and display only the rows which have the numbers between 90% to 99%, then if I change the cell A1 = 55% and cell B1 = 65% then the data would filter out only the rows which fulfill this criteria and hide all the others.


Thanks in advance for your help

 

[Luke M]

You can use a similar technique to what I describe here:

http://chandoo.org/wp/2011/11/18/formula-forensics-003/


The only difference is that you have more than 1 criteria, but Stephen showed how to do that here:

http://chandoo.org/wp/2011/11/18/formula-forensics-003/#comment-213428