Function Summary
Provides an easy method to add multiple Pair() functions together.
Function Arguments
|
Parameter Name
|
Description
|
Default
|
Optional
|
|---|---|---|---|
|
Pair1 |
Add a Pair() function. |
|
YES |
| ... | ... |
|
... |
| Pair34 | Add a Pair() function. |
|
YES |
Function Composition
|
Formula
|
Example
|
Explanation
|
|---|---|---|
|
= PairGroup(
Pair1
,... ,Pair34 ) |
= ReportDrill ( Drill_Order!B2 , , PairGroup ( Pair( F13:F14 , Drill_Order!H7 , TRUE ) ) , "Open Order Page" ) |
← Pair Group function embedded in ReportDrill formula. This example accepts a single pair . |
Function Example
|
From File
|
Worksheet
|
|---|---|
| InterjectBasic | Drill_Orders |