PairGroup()Estimated reading time: 1 minute
Provides an easy method to string multiple Pair() functions together in a single string argument with each Pair() delimited by a comma. This function is used as a helper function for both Formatting and Data functions. It is used to consolidate multiple Pair() functions so that they can all be applied by the same INTERJECT function. To see the functions that PairGroup() can be embedded in, view the Usable In These Functions section of this page. This function does have a Pair() limit of 34 Pairs. There can only be one PairGroup() embed so you cannot embed a PairGroup() inside another PairGroup().
|Pair1||This parameter is meant to have a Pair() function embedded in it||YES|
|Pair2||This parameter is meant to have another Pair() function embedded in it||YES|
|Pair34||This is the limit to the Pair() functions that can be embedded into a single PairGroup() function.||YES|
Excel Formula Bar Example
If you want to gain more context as to how this PairGroup() function works, it is sourced from Lab Drill: Financial Report.
Example Function Composition
|Argument Name||Example Mapping||Explanation|
|Function Name||=PairGroup()||This is the excel function name used to call the function. It is not meant to standalone and is meant to be embedded inside of a Formatting or Data function.|
|Pair1||Pair(L12:N12,”DateBegin”,TRUE)||This is the first pair function that is executed in this example. To better understand a pair function click Here|
|Pair2||Pair(M21,”Segment2”,True)||This is the second pair function that is executed in this example.|
|Pair3||Pair(F26:F125,”Segment1”,TRUE)||This is the third pair function that is executed in this example.|