Excerpt from Kevin Frank:
Earlier this year, in Virtual List Reporting, I used a custom function written by Agnes Barouh called CustomList to generate a couple basic lists, and then remarked, "These are the most simplistic examples of what this amazing custom function can do… even if you normally avoid CFs on general principle, I recommend making an exception for this one."
Well today I’m going to attempt to make good on that assertion. In case you aren’t already familiar with CustomList, it allows you to iteratively generate and/or parse lists using the full power of the FileMaker calculation engine. CustomList can process up to 500,000 rows — it is non-recursive and very fast — and today we’re going to use it to solve a variety of problems, both real world and theoretical.