Excel Tips
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.
January 20, 2022
I need to find a quick answer to a mathematical problem, and I don’t have a calculator. Can Excel help?
Use F9 in the Formula Bar to Test a Formula »
January 19, 2022
I have a complex formula that does not appear to be providing the correct result. The formula has multiple terms, and I am not sure which part is not working correctly.