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