[ Repository of Excelsior examples | More about Excelsior | Jocelyn Ireson-Paine's home page ]
This spreadsheet finds all text strings matching a given pattern. It uses the same style of recursive programming as the science-fiction generator, but this time applied to a "real-world" problem. This is something that came up in one of my consultancy-with-Excelsior jobs, when I had to create several sublists of dropdown options from a master list. Each sublist had to contain only those elements that matched a given pattern. This is difficult to code directly in Excel, but pretty easy in Excelsior. If you have to do such a task in Excel, you might find the formulae useful.
[ Repository of Excelsior examples | More about Excelsior | Jocelyn Ireson-Paine's home page ]