Use Excel's INDEX Function to Return an Array Vs Value

This video illustrates how to use Excel's INDEX function to return an array values rather than a single value. The result of the INDEX lookup can then be used with other functions such as SUM, MIN, COUNTIF etc
------------------------

[alexrosen]

Precise and thorough tutorial on the INDEX function. Thanks :-)

[francescope]

Excellent presentation. Thank you very much! I was looking too long for precisely the example with the countif function : )

[ashiqmir]

I wonder🤔 y such an Awesome video has only few

Really great 🎥video and the way of understanding.... Simply Awesome 👏👏👏👏👏👍👍👍👍

[maximilianthomaspfeiffer]

Hi, how can you return the value of the year when Ben for Example obtained the maximum profit, with and Index + Match Function?

[ahmedJaber]

How to use this to get a set of data rows while u dont specify how long. Eg u got data between two dates and for a client so suppose u are extracting all transactions. So u would get a varying number of rows regardless of how many. Was thinking if i could get in in a similar fashion as the array formulas like “unique” u dont copy the formula but it just paste data.

An added thing id i could control how it appears horizontally or vertically

[shellymarino]

Very helpful! I have a problem I wonder if someone would help with. My index/match formula works for all my tables in my query except for one and I'm not sure why. The tables are all aligned in one column on the same page and there are 8 tables and it pulls from all of them except table 4. I'm perplexed.

[FeralAkamaru]

When I press F9 it doesnt show me each of the values. Only shows me the end result.