Intersect Operator in Excel can be used to find the intersecting value(s) of two lists/ranges. This an unusual operator as it is represented by a space character (yes that’s right).
If you use a space character in between two ranges, then it becomes the intersect operator in Excel.
In this video, you’ll learn how to use Intersect Operator in Excel to find:
— The intersection of a single row and column.
— The intersection of multiple rows and columns.
— The intersection of Named Ranges.
Read More:
Free Excel Course –
Paid Online Training –
Best Excel Books:
⚙️ Gear I Recommend:
Camera –
Screen Recorder – techsmith.z6rjha.net/26D9Q
USB Mic –
Wireless Mic:
Lighting –
Subscribe to get awesome Excel Tips every week:
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial
Watch more new videos about Excel Office | Synthesized by Mindovermetal English
3:15 In newer versions of Excel, this is valid – no #VALUE error. It will return 649 523 – as a dynamic array! This is really cool!
Awesome ! The dislikes are probably from people who could not understand it.
Wanted to find the intersection of two curves. Excel can't do anything.
Great explanation 👍
Excellent explanation. Understandable and to the point
I am trying to use intersection operator but this is different from what your video has, I have an excel sheet in which I want intersection from certain columns, I am a garments merchant, I am selling on different marketplaces, like flipkart, snapdeal, amazon etc, each product has an SKU, Colour and size(S,M,L,XL,XXL). I want to calculate how many units of a particular SKU with a particular color and size are sold out, countif works with one range and one criteria but I have more ranges and more criteria, I guess intersection may work, please help me with this
love it, never thought of using that..awesome
Excellent, Sumit. Thank you. Steve
Great video! Its a little known function, I think.