Category Archives for "Excel Tips"

4 What is Intersect Operator in Excel and How to Use it

Watch Video – Using Intersect Operator in Excel 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. […]

Continue reading >>