Transformer
05-17-2013, 12:32 AM
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 […]http://stats.wordpress.com/b.gif?host=usefulgyaan.wordpress.com&blog=50473542 &post=640&subd=usefulgyaan&ref=&feed=1
Intersection of Overlapping Ranges:Space Operator (http://usefulgyaan.wordpress.com/2013/05/13/intersection-of-overlapping-rangesspace-operator/)
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 […]http://stats.wordpress.com/b.gif?host=usefulgyaan.wordpress.com&blog=50473542 &post=640&subd=usefulgyaan&ref=&feed=1
Intersection of Overlapping Ranges:Space Operator (http://usefulgyaan.wordpress.com/2013/05/13/intersection-of-overlapping-rangesspace-operator/)