Author: Oscar Cronquist Article last updated on October 07, 2017

Find records between two numbers

Filter records between 13 and 16 can also be done using Advanced filter or in Excel 2007 creating a table.

Array formula in A19:

=INDEX($A$2:$D$9, SMALL(IF(($D$2:$D$9<=$B$14)*($D$2:$D$9>=$B$13), ROW($D$2:$D$9)-MIN(ROW($D$2:$D$9))+1), ROW(1:1)), COLUMN(A1:A1)) + CTRL + SHIFT + ENTER

copied right to D19 and then copied down as far as needed.

Download excel file for this tutorial.

Find records between two numbers in a table.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

MATCH(lookup_value, lookup_array, [match_type]
Returns the relative position of an item in an array that matches a specified value

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

ROW(reference) returns the rownumber of a reference

COLUMN(reference) returns the column number of a reference

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