![]() Now you could do even that with a help of programming in VBA, but how many people in a regular company possess those skills? ![]() Even if you create dynamic formulas using INDIRECT combined with INDEX/MATCH, they will still fall short if someone wishes to change the dimensions in which they do analysis (for example switch from figures by Brands to figures by Country). You cannot tell formulas in cells “B1:B1000” to transpose and become formulas in cells “B1:ZZ1”, yet to still show expected results. Flexibility – No matter how smart and “dynamic” your formulas are, they are still just “formulas” written in cells.There were several problems with models created using Excel formulas. When created, these models were all performing as expected, but as time passed they all showed flaws. If they were more advanced Excel users, they would also use SUMPRODUCT and OFFSET/INDIRECT to create somewhat dynamic final results. ![]() When doing any kind of modeling, colleagues would rely on Excel formulas created across the whole workbook, connected with VLOOKUP od INDEX/MATCH functions. To use Measures in Excel 2010, you first needed to install PowerPivot add-in, since it is not a part of the application itself. Measures are with us since the Excel 2010, yet I’ve seen only a few people using them while doing analysis or data manipulation in any way.
0 Comments
Leave a Reply. |