Home Courses Data Analysis: Take it to the MAX Course materials Lectures 4.4 Intersection

4.4 Intersection

Course subject(s) 4. Structure and Named Ranges

The use of name ranges makes your formulas a lot more readable. You can refer to given names instead of cells. If you refer to two name ranges (in a column and row) it gives back the intersection.

Video
Subtitles
Other

Sorry but there don't seem to be any downloads..

Subtitles (captions) in other languages than provided can be viewed at YouTube. Select your language in the CC-button of YouTube.

Creative Commons License
Data Analysis: Take it to the Max by TU Delft OpenCourseWare is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.
Based on a work at https://ocw.tudelft.nl/courses/data-analysis-take-it-to-the-max/.
Back to top