Article updated on November 20, 2007

Problem: How sort out all dates that don´t meet the criteria?
Criteria "Sort out dates later than 2006-11-18"


Column A contains all data
Column B contains sorted data
C1 contains criteria date

Column B contains: =IFERROR(INDEX($A$1:$A$20, SMALL(IF($A$1:$A$20<$C$1, ROW($A$1:$A$20), ""), ROW(1:1))), "") + Ctrl + Shift + Enter.

Lets divide the formula for easy explanation:
IF($A$1:$A$20<$C, ROW($A$1:$A$20), "") checks the criteria, if met then the actual cell value row number is the result.

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

Index() uses the rownumber to "get" the sorted out values.

IFFERROR() removes the num# error.