By Andrew Gould

Download files here https://www.wiseowl.co.uk/excel/videos/excel-general/excel-implicit-intersection/

If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can join this channel to get access to perks:
https://www.youtube.com/channel/UCbi5G5PjWBaQUFy7XU_O7yw/join

Or you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!

This video explains how you can control the behaviour of range names in modern versions of Excel using the implicit intersection, or @ operator. You'll learn about the traditional behaviour of range names and how to perform intersection. You'll see why it's sometimes necessary to use the implicit intersection operator in functions like AND, OR and NETWORKDAYS. You'll also see how dynamic arrays can sometimes cause circular references and how to use the implicit intersection operator to resolve them.

Chapters
00:00 Topic List
00:54 Recap of Dynamic Spilled Arrays
03:41 The Implicit Intersection Operator
06:27 Basic Logical Tests
07:42 Intersecting Names in Functions
10:59 The NetWorkDays Function
14:07 A Basic Cashflow System
15:48 Circular References
19:27 Returning Only Negative Balances
22:03 More Circular References

Visit https://www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Power BI, DAX, VBA, Python, Visual C#, Microsoft SQL Server, SQL Server Reporting Services SSRS, SQL Server Integration Services SSIS, Microsoft Access and more!