An Excel table has three columns:

We want to sort rows of the table according to different segments of the 3^rd column in ascending order. The 1^st segment: the 3^rd column value≤50; the 2^nd segment: 700 < the 3^rd column value < 720; the 3^rd segment: the other cases (50 < the 3^rd column value < 700 or the 3^rd column value > 720). Below is the expected result:

Use SPL XLL to do this:

=spl("=?.enum@n([$[?<=50],$[?>=701 && ?<=720]],~3).conj(~.sort(~3))",A1:C15)

enum()function performs enumerated grouping according to value of the specified string expression; $[] represents a string; @n option enables putting members that do not meet the enumerated conditions in one and separate group. ~ is the current member of a sequence; and ~3 is the 3^rd member of a sequence.

Source: https://stackoverflow.com/questions/78140929/excel-vba-custom-sort