Background Sometimes we have to sum the intersections of multiple ranges. Can you think of a formula? Using INDEX MATCH? INDIRECT? And nested IF function? I go through exactly the same thought process until I meet Intersection operator. Don’t panic
In this article, I will show you how to add value directly to existing cells in Excel with Paste special feature. These steps can also be used on other calculations.
Very often we have to find out the last value in a column or in a row. When there are so many ways available in the internet, they all have a common issue – too long and complicated. If the
Background If you click into this article, you must be looking for a way to solve the below problems. How to get the formula displayed as text in Excel? How to display formula rather than result in Excel? How to
Background Excel has over 1 million rows and more than 10000 columns. Sometimes the navigation between different cells can be difficult and quite time-consuming. Although you might have more than 10000 cells, most of the time there are only a
Background Sometimes we may want to sum and count cells based on background colour of a cells. I personally don’t suggest using background colour frequently. I do think background colour has its advantage. You can check out 5 Golden Rules
