Max,

Thanks! That did it, and it works great.

I am about done with this file that you have been helping me on. It is
pretty big now -- about 35MB. This is helping to shave hours off of
generating our monthly order guide that we send out to our customers. Thanks
for all of your help. I could not have done it without you.

Best Regards,
Chad

"Max" wrote:

Chad,
Suggest that you apply autofilter on the upstream formulated criteria col
for quick diagnosis. Just scroll right down in the autofilter droplist, check
for error values such as #N/A, #VALUE, etc. These are the usual culprits
which break the formulas flow. And the underlying causes would usually lie
further upstream, in the source data's consistency. It may actually be mixed
text (alphas) / nums data while you had thought it's pure nums/text nums
right down the col (eg in Import's col C).

Instead of:
=IF((Import!U10),Import!C1+ROW()/10^10,"")

Try:
=IF(Import!U10,IF(ISNUMBER(Import!C1+0),Import!C1 +ROW()/10^10,""),"")

Above should give you better results
in the face of mixed source data in Import's col C
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
---