00:00In a previous video I demonstrated how you can find intersection data using
00:03index and match function. Now I'm going to show you how you can use an intersect
00:07operator or also known as space operator. Let's say for example you want to find
00:11what Ella make in 2021. You're gonna say equal and you highlight Ella's row like
00:16this and then you're gonna press a spacebar and you're gonna highlight 2021
00:20like this and you'll get the value of 11 million dollars. Likewise you can find
00:24the total what Ella made from 2019 to 2022. You're gonna say equal and you're
00:28gonna highlight Ella again one more time, spacebar and then 2019 all the way to
00:332022 and hit enter and you realize that it produced an array of numbers. What you
00:38can do is you can encapsulate the array of number under the sum function and then
00:42you get the total number made for that year. You can also apply the same rule if
00:46you have multiple users for 2018 say Hayley and Mary and how much did Hayley and
00:51Mary make between 2019 and 2022. In the next video I'm gonna demonstrate what are
00:56the practical application for this technique. Stay tuned.
Comments