...
Operator | Meaning | Example | Description |
|---|---|---|---|
: (colon) | Range operator | A1:B1 | Makes one reference to multiple cells between the two specified references. |
, (comma) | Union operator | A1:B1,A2:B2 | Returns the intersection of multiple ranges. |
(space) | Intersection operator | A1:B1 A2:B2 | Finds the intersection of the two ranges. |
| Info |
|---|
Read next Built-in Functions , Column filter |