Microsoft Office Forums - View Single Post - [Solved] Take String of numbers, expand ranges, sort, then compress back into ranges

Guessed · 07-21-2016, 10:04 PM

I've discovered that the Recordset method doesn't actually allow use of Select Distinct in the SQL since we don't have an external table to apply the query to. A recordset does allow easy sorting though so it is still worthwhile using it for that purpose.

I've noticed that there is a flaw in the fcnConcatenateNumbers function when a run is only two numbers long. This is causing 13 to disappear from the result in the massive number set you posted above.