Skip to content
REFERENCE

U.HSORT

Summary

Dynamically sorts rows of data (Descriptions use "column" and "row" consistent with the vertical flavor of the function; flip these terms to describe the horizontal flavor)

Syntax

=U.HSORT(data, [sort_params], [sort_list], [sort_list], [sort_list])

Parameters

Parameter Required Description
data Yes The rows of data to be sorted. If only a valid topic is provided, the first page of that report will be used unless there is a spaced pipe and page indicator following the topic (e.g.
[sort_params] No The range containing the sort criteria applied to columns in data range. A nested sort will be applied to rows in order of specified sort parameters. If not set, then rows are sorted by the leftmost column in ascending order. If "types" provided and no other params set, then a report of available sort types is returned
[sort_list] No A list or lists of values to be used as the basis for list-based sorting Lists are applied to list-based sort criteria in the order specified
[sort_list] No A list or lists of values to be used as the basis for list-based sorting Lists are applied to list-based sort criteria in the order specified
[sort_list] No A list or lists of values to be used as the basis for list-based sorting Lists are applied to list-based sort criteria in the order specified

Behavior

The documented public interface is supported by the current U Add-in source signature and the maintained Usage Examples workbook. Optional parameters are shown in square brackets in the syntax above; omit the brackets when entering a formula.

Return Value

Returns the function result or action status described by the formula and parameters above. The maintained sources do not define a narrower, stable return contract for this function.

Examples

=U.HSORT(B7:I20,1,V245:V250)

Notes

  • Formula examples are preserved from maintained workbook usage and normalized to the current U. prefix.
  • Complete formulas demonstrate working patterns; they do not imply that undocumented option values are supported.
  • Where maintained sources do not specify every accepted value, default, or error message, this page does not infer one.
  • For functions that perform actions, use a visible trigger or supported block/throttle parameter to avoid unintended repetition during recalculation.