Excel INDEX Function - 4 Examples Easy to Advanced

Описание к видео Excel INDEX Function - 4 Examples Easy to Advanced

The INDEX function returns a value or reference, based on a row and column number.

Watch this video to see how to use the Excel INDEX function, and combine it with other functions. There are 4 INDEX function examples in this video.

Ex 1: (Beginner) Find sales amount for selected month
Ex 2: (Intermediate) Get reference to specified row, column, area
Ex 3: (Advanced) Create a dynamic range based on count
Ex 4: (Advanced) Sort text in alphabetical order

For more INDEX and MATCH function examples, go to my Contextures website:
https://www.contextures.com/xlfunctio...

Комментарии

Информация по комментариям в разработке

Похожие видео