IntersectionOfRanges
Returns the address of the intersection of the two specified ranges.
Usage
@Intersection(<Range1>, <Range2>)
| Argument Name |
Description |
| Range1 |
The first range. |
| Range2 |
The second range. |
Examples
@Intersection
function example
|
A |
B |
C |
D |
E |
F |
G |
| 1 |
| 2 |
Intersection: |
5.0 |
| 3 |
|
4.0 |
| 4 |
|
3.0 |
| 5 |
|
2.0 |
| 6 |
|
1.0 |
| 7 |
|
0.0 |
1.0 |
2.0 |
3.0 |
4.0 |
5.0 |
| 9 |
Intersection: |
5.0 |
| 10 |
|
4.0 |
| 11 |
|
3.0 |
| 12 |
|
2.0 |
| 13 |
|
1.0 |
| 14 |
|
|
1.0 |
2.0 |
3.0 |
4.0 |
5.0 |
| Procedure |
|
| |
Method |
Overload |
ErrorHandlingMode |
|
| |
|
Argument |
Value |
Comment |
| OnAfterBuild |
|
| |
SetEntry
|
Text
|
|
|
| |
|
Address |
Data.Range |
|
| |
|
CellByCell |
True |
|
| |
|
Entry |
@Intersection(Range1,Range2) |
|
| |
SetEntry
|
Text
|
|
|
| |
|
Address |
Data.Range2 |
|
| |
|
CellByCell |
True |
|
| |
|
Entry |
@Intersection(Range3,Range4) |
|
|
A |
B |
C |
D |
E |
F |
G |
| 1 |
| 2 |
Intersection: |
5.0 |
| 3 |
$B$7 |
4.0 |
| 4 |
|
3.0 |
| 5 |
|
2.0 |
| 6 |
|
1.0 |
| 7 |
|
0.0 |
1.0 |
2.0 |
3.0 |
4.0 |
5.0 |
| 9 |
Intersection: |
5.0 |
| 10 |
|
4.0 |
| 11 |
|
3.0 |
| 12 |
|
2.0 |
| 13 |
|
1.0 |
| 14 |
|
|
1.0 |
2.0 |
3.0 |
4.0 |
5.0 |