Excel Tips
February 2, 2022
Our company uses an ancient add-in that still is not compatible with 64-bit, so we are stuck with 32-bit.
February 1, 2022
I have a workbook with 12 monthly sales reports. Each worksheet has identical rows and columns that show sales by week and region. The worksheets are named January, February, …, December. I want to have a Total worksheet that sums cell E5 on all the other worksheets.
January 31, 2022
I have some baseball data with a column showing W or L for wins and losses. I want to calculate the longest winning streak.
Understand Implicit Intersection »
January 28, 2022
In the previous article, 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.
Why Use the Intersection Operator? »
January 27, 2022
What is the purpose of the intersection operator?
January 26, 2022
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 »
January 25, 2022
Sometimes when I change a cell in Excel, the formulas do not calculate. Below, cell C2 indicates that two plus two is not four.
Highlight All Formula Cells Using Conditional Formatting »
January 24, 2022
I need to audit a worksheet created by a former co-worker. How can I mark all formula cells?
When Entering a Formula, You Get the Formula Instead of the Result »
January 21, 2022
When entering a formula, Excel shows me the formula in the cell instead of the result.