UsefulGyaan Has Posted the Following On 05-13-2013 09:24 AM:

We all know about “:“*operator. If one writes A1:A10 then it refers to a continuous range from A1 to A10. There is one more operator Space operator.*If this operator is used to separate two or more overlapping ranges then it refers to intersection of those ranges. e.g. *A3:M3 D1:D6*would return D3*since it lies at the […]





Intersection of Overlapping Ranges:Space Operator