Max,

THANK YOU!!!!!!!!

I don't know how I did that. I think that I was trying to copy and replace
it in the formula bar, but I must have actually added the copy to the end.
As far as not seeing it, I don't know...call it stupidity.

Anyway, I knew that I must have been overlooking something. Thank you for
your time and patience! This will help me a lot.

I hope that I don't have to bother you on this anymore.

Best Regards,
Chad

"Max" wrote:

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