Understand Implicit Intersection

January 28, 2022 - by Bill Jelen

Understand Implicit Intersection

In the previous article, Why use the intersection operator, notice that the formulas in the last two figures were outside of the range B:I. Before Dynamic Arrays are introduced to Office 365, those formulas would not work in that area due to a feature called “Implicit Intersection”. Here is how it works.

continue reading »

More Reading

Why Use the Intersection Operator?

Why Use the Intersection Operator? »

January 27, 2022 - by Bill Jelen

What is the purpose of the intersection operator?

Calculate One Range

Calculate One Range »

January 26, 2022 - by Bill Jelen

I have a workbook that takes 3 minutes to calculate. I changed to manual calculation mode so I can enter data without waiting for a recalculation after each data entry. I just changed 10 cells and I only want to recalculate the 10 rows that rely on those cells. I don’t want to wait 3 minutes when there are only 10 cells that need recalculated.

You Change a Cell in Excel but the Formulas Do Not Calculate

You Change a Cell in Excel but the Formulas Do Not Calculate »

January 25, 2022 - by Bill Jelen

Sometimes when I change a cell in Excel, the formulas do not calculate. Below, cell C2 indicates that two plus two is not four.

read more articles »

Featured Products

Analyzing Data With Pivot Tables in Excel - Online Course

January 2022

Bill Jelen has rolled all of his favorite Excel Pivot Table tips and techniques into a new guide on the Retrieve platform.

Your Excel Survival Kit - Second Edition

March 2021

This book helps you realize that Excel is on your side. It can be your friend, not your enemy. If and when you upgrade your Excel skills you will experience many positives: you will learn to love Excel, you will learn how to use Excel to become an invaluable asset in your workplace.

Excel Insights – A Microsoft MVP Guide to the Best Parts of Excel

January 2020

There are fewer than 100 Excel MVPs worldwide. 24 of them have contributed to this book. Written, edited, reviewed and printed by Excel MVPs, this is practical Excel passion undiluted, with each MVP highlighting some of their favorite topics.

Saving Time with Excel - Online Course

January 2022

Be more efficient in Excel with these time-saving techniques in Excel.

see more products »