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 |