Skip to content
REFERENCE

U.VCOMBINATIONS

Summary

Returns all cominations of the specified input rows (Descriptions use "column" and "row" consistent with the vertical flavor of the function; flip these terms to describe the horizontal flavor)

Syntax

=U.VCOMBINATIONS(range, range, [range], [block_sizes], [label_depths])

Parameters

Parameter Required Description
range Yes A range of data from whose rows combinations will be derived
range Yes A range of data from whose rows combinations will be derived
[range] No A range of data from whose rows combinations will be derived
[block_sizes] No The number of rows to include in a single combination. If fewer block sizes are given than ranges of data, the last block size specified is applied to ranges missing block size info
[label_depths] No The number of rows that contain labels instead of data to be combined. If fewer labels depths are given than ranges of data, the last value specified is applied to ranges missing label depth info; make number negative align labels to top of result

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.VCOMBINATIONS(B4:B6,C4:C6)

=U.VCOMBINATIONS((B17:B19,C17:D19))

=U.VCOMBINATIONS(B31:B34,C30:D34,,,{1,2})

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.