Last answered:

01 Aug 2024

Posted on:

18 Jan 2024

0

Specifying the array in Index formula

In the lecture when specifying the array for the Index formula you used a single column. In the Exercise you used the entire table. Why?? Whats the difference between the two? 

3 answers ( 0 marked as helpful)
Instructor
Posted on:

17 Feb 2024

0

Hi abhinav!

Thanks for reaching out.


Please pause the video at 1:38. You will see that the INDEX() function works both with an array, as well as a column reference. Whichever option we choose to use, we need to provide a row number afterwards to indicate to Excel which row from the selection we are interested in. Therefore, in the lecture/exercise we opt for a different data subset to work with.


Hope this helps.
Best,
Martin

Posted on:

22 Jul 2024

0

What's the shortcut you use at 6:19 to update the values in the table?

Instructor
Posted on:

01 Aug 2024

0

Hi Stefani!

Thanks for reaching out. Please accept my apologies for the delayed response.

It's a mere Ctrl + V, i.e. Paste combination. It allows us to paste the formula from J4, while preserving its row and column references (fixed through $ before the column letter or the row number).

Hope this helps but please feel free to get back to us should you need further clarification. Thank you.

Kind regards,
Martin

Submit an answer