whoops, missed out correcting one "A1" to your "C1" earlier

Use this in A1, copy down (front IF trap modified to trap non-numerics):
=IF(OR(Import!C1="",ISERROR(Import!C1+0)),"",IF(AN D(Import!C1+0=103000,Import!C1+0<=705999),Import! C1+ROW()/10^10,""))

Pl press the YES buttons in ALL responses which helped
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,000 Files:370 Subscribers:66
xdemechanik
---

Max,

I responded yes to all of your responses. Thank you!

When I put in the formula below, now I have "True" in cells A1:A4000. Any
ideas?

"Max" wrote:

whoops, missed out correcting one "A1" to your "C1" earlier

Use this in A1, copy down (front IF trap modified to trap non-numerics):
=IF(OR(Import!C1="",ISERROR(Import!C1+0)),"",IF(AN D(Import!C1+0=103000,Import!C1+0<=705999),Import! C1+ROW()/10^10,""))

Pl press the YES buttons in ALL responses which helped
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,000 Files:370 Subscribers:66
xdemechanik
---

"Chad F" wrote
Max,
I responded yes to all of your responses. Thank you!

Yes, I can see that. Thanks

When I put in the formula below, now I have "True" in cells A1:A4000.
Any ideas?

It should work fine. You can proof it by manually entering some test nums
within and outside the range into Import's col C and see the returns

Probably your imported data contains some other "invisible" stuff which
needs to be cleaned off.

Try this link for Dave M's Sub TrimALL():
http://www.mvps.org/dmcritchie/excel/join.htm#trimall

Run the sub on your imported data ..
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,000 Files:370 Subscribers:66
xdemechanik
---

Max,

I tried the trim macro that you referenced, but nothing happened. So, I
created two new sheets, one named "Test Import" and one named "Test Results".
On the Test Import sheet, I keyed in my item numbers from scratch (not
copied from another source). I then entered the same formulas that you gave
me for columns A and B on the Test Results sheet and copied them down to row
4000. Now all I have in A:1 thru A:4000 is "#NAME?", and I have no results
in column B. Any suggestions?

"Max" wrote:

"Chad F" wrote
Max,
I responded yes to all of your responses. Thank you!

Yes, I can see that. Thanks

When I put in the formula below, now I have "True" in cells A1:A4000.
Any ideas?

It should work fine. You can proof it by manually entering some test nums
within and outside the range into Import's col C and see the returns

Probably your imported data contains some other "invisible" stuff which
needs to be cleaned off.

Try this link for Dave M's Sub TrimALL():
http://www.mvps.org/dmcritchie/excel/join.htm#trimall

Run the sub on your imported data ..
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,000 Files:370 Subscribers:66
xdemechanik
---

Chad,

Can you upload your sample file using a free filehost,
then post a link to it here?

You can use this "easy-to-use" free filehost to upload:
http://www.freefilehosting.net/

Copy the "direct link" which is generated after you upload,
then paste it here in your reply

(desensitize the data in your sample as required)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,000 Files:370 Subscribers:66
xdemechanik
---
"Chad F" wrote in message
...
Max,

I tried the trim macro that you referenced, but nothing happened. So, I
created two new sheets, one named "Test Import" and one named "Test
Results".
On the Test Import sheet, I keyed in my item numbers from scratch (not
copied from another source). I then entered the same formulas that you
gave
me for columns A and B on the Test Results sheet and copied them down to
row
4000. Now all I have in A:1 thru A:4000 is "#NAME?", and I have no
results
in column B. Any suggestions?

Chad,

Here's my working sample for easy ref :
http://freefilehosting.net/download/440g0
Extract multiple num results in another sht n sort ascending.xls

In A1:
=IF(OR(Import!A1="",ISERROR(Import!A1+0)),"",
IF(AND(Import!A1+0=103000,Import!A1+0<=705999),Im port!A1+ROW()/10^10,""))

In B1:
=IF(ROW()COUNT(A:A),"",INDEX(Import!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 "Import".
Minimize/hide col A. Col B returns the required ascending sort of nums
(inclusive text nums) in source data within the specified range, ie between
103000 to 705999 (inclusive)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,000 Files:370 Subscribers:66
xdemechanik
---

Max,

Here is my file. Please take a look and see if I am messing something up.
http://freefilehosting.net/download/440g5

Thanks,
Chad

"Max" wrote:

Chad,

Here's my working sample for easy ref :
http://freefilehosting.net/download/440g0
Extract multiple num results in another sht n sort ascending.xls

In A1:
=IF(OR(Import!A1="",ISERROR(Import!A1+0)),"",
IF(AND(Import!A1+0=103000,Import!A1+0<=705999),Im port!A1+ROW()/10^10,""))

In B1:
=IF(ROW()COUNT(A:A),"",INDEX(Import!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 "Import".
Minimize/hide col A. Col B returns the required ascending sort of nums
(inclusive text nums) in source data within the specified range, ie between
103000 to 705999 (inclusive)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,000 Files:370 Subscribers:66
xdemechanik
---

In Sheet1,
you had a "double" formula in A1 down which was incorrect, ie:
=IF(OR(Import!C1="",ISERROR(Import!C1+0)),"",IF(AN D(Import!C1+0=103000,Import!C1+0<=705999),Import! C1+ROW()/10^10,""))
=IF(OR(Import!C1="",ISERROR(Import!C1+0)),"",IF(AN D(Import!C1+0=103000,Import!C1+0<=705999),Import! C1+ROW()/10^10,""))

(How did you end up with the double w/o noticing it?)

Just delete away one of the double, ie correct it in A1 to:
=IF(OR(Import!C1="",ISERROR(Import!C1+0)),"",IF(AN D(Import!C1+0=103000,Import!C1+0<=705999),Import! C1+ROW()/10^10,""))
then copy A1 down, and the results will magically appear in col B
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,000 Files:370 Subscribers:66
xdemechanik
---
"Chad F" wrote in message
...
Max,

Here is my file. Please take a look and see if I am messing something up.
http://freefilehosting.net/download/440g5

Thanks,
Chad