FileMaker Pro Custom Functions

//_fn_Insert2SortedNumList(SList; Value; Order) /* Function: insert a numeric value into a sorted numeric list and keep the list in correct sorted order Parameters: SList: pre-sorted numeric list Value: the numeric value to insert Order: indicate the order type of the SList; "A"=ascending list; "D"=descending list Requirement: Slist must be a sorted list */ Let ( [ L=ValueCount(SList); V1= GetAsNumber(GetValue(SList;1)) ] ; Case ( IsEmpty(Value); SList; //no Value return the SList L=0; value; Order="D"; Case(value ≥ V1; value & ¶ & SList; V1 & ¶ & _fn_Insert2SortedNumList(RightValues(SList; L-1); Value; Order) ); Order="A"; Case(value ≤ V1; value & ¶ & SList; V1 & ¶ & _fn_Insert2SortedNumList(RightValues(SList; L-1); Value; Order) ); SList ) )
 Then copy & paste into FileMaker Advanced's Edit Custom Function window.