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. Extract numbers and text from a range using array formula in excel
3. Match two criteria and return multiple rows in excel
4. Extract dates and adjacent value in a range using a date critera in excel
5. Extract cell values in a range using a criterion in excel
6. Sequencing and numbering of batches in excel
7. Extract unique values from a range using array formula in excel