2 – Excel Functions 1

Module 5 – Data Structuring This chapter focuses on importing/exploring data, automating reports, UI, and other general VBA topics. While not quantitative in nature, these skills are frequently used in finance and should not be glossed over.

2 – Excel Functions 1

Please sign up for the course before starting the lesson.
  • Hi, Can you explain why we don’t have to enter [column_num] for the combined function Match/Index? I saw we had to enter it before for Match function. Is it because there were multiple columns in the previous example with the same/similar string? I just want to make sure. Thanks in advance!

  • Hi,

    When I use the drag feature, it just copies the same number into all the cells below (“2” in this case) instead of changing the formula accordingly for each different cell. (I am suppose to get 3,4,5,6,7,8,9 instead)

    Can you explain why it copies down the same number instead of giving me different calculations for each cell? (I see it changed the cell names but still shows me “2” instead of calculating what is inside each cell based on the formulas)

    Could it possibly be a glitch in software?

    Thanks in advance!

    • Just to be clear, I did not use any “$” sign for the first example and there wasn’t any in the cells (I double checked). I was still shown the same result from the first cell but with different cell names (1+A15, 1+A16, etc.)

Back to: VBA > VBA 01 - Advanced Excel Features