12-19-2025, 03:17 PM
Yes Pete, that method is easier for sorting string values which I assume the numeric values in your example are strings. But is the array a multi D? In fact, even if it isn't, it does a great job of using multi data elements.
I like the use of numeric values for the accuracy of formula results, I haven't been able to trust string conversions to numeric values mostly because I'm often mis-converting and winding up with a zero value . for example I'll try something like Bob = val(Bob$) whereas Bob = 45 has a level of accuracy that I can depend on.
But that being said, sorting is challenging and I like your method of a string array which captures all the elements of a multi D. Thanks for that.
I like the use of numeric values for the accuracy of formula results, I haven't been able to trust string conversions to numeric values mostly because I'm often mis-converting and winding up with a zero value . for example I'll try something like Bob = val(Bob$) whereas Bob = 45 has a level of accuracy that I can depend on.
But that being said, sorting is challenging and I like your method of a string array which captures all the elements of a multi D. Thanks for that.
