Robert H. Gascon’s comment from my last post convinced me that I should be using the INDEX function for dynamic ranges not the volatile OFFSET function. Continue reading
Dynamic Ranges Using Index Function
Posts Tagged → Indirect
What is this formula doing?
=SUMPRODUCT(MID(G2,{1;2;3},1)*1) I found this formula in a notebook. Can you understand it’s purpose? I’ll explain it in this post. I’ll also expand it for a more complex case. Continue reading
2018 World Cup and Excel !
Last week I was helping a friend build a World Cup pool in Excel. It was fun debating the pool’s scoring rules. I also taught him a few Excel tricks along the way. Continue reading
Video 00139 Beyond 3D Formulas
Excel’s 3D formulas allow you to work with values from the same range in different sheets. However, not all Excel functions work with 3D formulas. Read my post to see how they work, how to go beyond 3D formulas and how to often avoid complex formulas with proper spreadsheet design! Continue reading