If head = TRUE (default FALSE) then the first row of R1 is assumed to contain column headings and is retained as the heading of the output. SORTRows(R1, k, head) – returns an array of the same size and shape as R1 which sorts the rows in R1 based on the sort keys consisting of the first k columns of R1 (default 1).
Real Statistics Functions: The following array functions contained in the Real Statistics Resource Pack are used to sort rows in an array or cell range. It will, therefore, be useful to sort data by rows based on a sort key (which corresponds to the heading of one of the columns). In most of the statistical analyses that we perform, each row in a range will contain data for a single subject in a sample and the columns correspond to the variables under study.
