Guess I was still floundering <g trying to grasp the underlying logic behind
the OP's intent from the descript given. And thinking maybe there exists a
better way (another formula ?) to achieve the same intent w/o getting into
sys resource issues.
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----

"Biff" wrote:

Hi!

There does appear to be a circular ref issue but that
shouldn't cause Excel to crash although that may be a
contributing factor!

By my calculations, you have 112,473 *robust* array
formulas just for this one operation. I think you're
having a serious system resource issue.

This site may have something to help:

http://www.decisionmodels.com/

Biff