"Biff" wrote:
Max, I'm wondering if you did a full application test on this ..
Obviously not g .
Btw, do you do full testing on detailed posts
like this one before you respond ?
6 sheets with 65536 rows of data, 3000 rows of lookup values
and 6 columns of formulas.
What kind of calc time did that take?
Ok, I just did that, on my laptop (3 year old IBM T30) Excel 97:
Took about 3 mins to fill the formulas & complete calc.
Perhaps you would like to indicate what other pre-emptive caveats
should have been written in my suggestion ?
Like always, it was only a suggestion for the OP to try out.
And nothing is ever stated in my posts that precludes
any others from posting other, possibly better suggestions
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--