And if you additionally, would like the auto-extracts in Sheet2 to be in
sorted ascending order, use this set of formulas

In Sheet2
In A1:
=IF(Sheet1!A1="","",IF(LEFT(Sheet1!A1,3)="803",She et1!A1+ROW()/10^10,""))

In B1:
=IF(ROW()COUNT(A:A),"",INDEX(Sheet1!A:A,MATCH(SMA LL(A:A,ROW()),A:A,0)))
Copy A1:B1 down to cover the max expected extent of source data in Sheet1's
col A, say down to B100? Minimize/hide col A. Col B returns the desired
results in sorted ascending order, all neatly bunched at the top.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,000 Files:370 Subscribers:66
xdemechanik
---