Question: I have a list and I want to filter out all rows that has a value (Column C) that is bigger or equal than zero and smaller or equal than three?

Answer: Yellow cells are user  input cells.

Here is the formula in H2:J12

=IF(SUM(IF(($C$2:$C$11<=$F$2)*($C$2:$C$11>=$F$1), 1, 0))<ROW()-1, "", INDEX($A$2:$C$11, SMALL(IF(($C$2:$C$11<=$F$2)*($C$2:$C$11>=$F$1), ROW($C$2:$C$11)-1, ""), ROW()-1), COLUMN()-7)) + Ctrl + Shift + Enter

Download excel sample file for this tutorial.
Extract all rows that contain a value between this and that.xls
(Excel 97-2003 Workbook *.xls)

Functions in this article:

IF(logical_test;[value_if:true];[value_if_false])
Checks whether a condition is met, and returns one value if TRUE, and another value if FALSE

INDEX(array,row_num,[column_num])
Returns a value or reference of the cell at the intersection of a particular row and column, in a given range

SMALL(array,k) returns the k-th smallest row number in this data set.

ROW(reference) returns the rownumber of a reference

SUM(number1,[number2],)
Adds all the numbers in a range of cells

COLUMN(reference)
returns the column number of a reference

Related posts:

1. Extract all rows from a range that meet criteria in one column in excel
2. Filter unique rows and sort by date using array formula in excel
3. Filter duplicate rows and sort by date using array formula in excel
4. Extract numbers and text from a range using array formula in excel
5. Match two criteria and return multiple rows in excel
6. Extract dates and adjacent value in a range using a date critera in excel
7. Extract cell values in a range using a criterion in excel
8. Sequencing and numbering of batches in excel
9. How to extract a list of duplicates of a column in excel
10. Extract unique values from a range using array formula in excel