Formulas: Is the TEXTLIST function used?


When is this a problem?

Always a problem.


Why is this a problem?

Using TEXTLIST requires a lot of memory.


How to correct:

Using two-dimensional modules and Boolean flags with ANY is a good alternative. Click here to see an ANY instead of TEXTLIST document. Use FIRSTNONBLANK and LASTNONBLANK with ANY and ALL.


More information:

Planual 2.02-11

Anapedia: x[ANY:y]

Model Optimization Checklist