Thank you all for your answers they have all worked fine. One more questiuon
though using the formula that Max wrote, how can I change it to read row 2. I
have inserted a header in row 1 and therefore miss the first line of data
when i use the formula in D2 instead of D1

"Max" wrote:

An easy formulas play which can deliver it for you ..
Source data as posted running in A1:B1 down
In C1: =IF(AND(B1DATE(2008,12,31),B1<DATE(2010,1,1)),ROW (),"")
In D1: =IF(ROW()COUNT(C:C),"",INDEX(A:A,SMALL(C:C,ROW()) ))
Copy C1:D1 down to cover the max expected extent of source data.
Hide/minimize col C. Col D will return the required results, all neatly
bunched at the top
Any good? hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Rob" wrote:
.. In the example the first value in Column C is 1042
i.e the first value that meets the criteria and excludes 1040
which is outside this range. Is there any way
to automatically sort the data ?