Most people only know one way to use the INDEX function, but there are 5 tricks that will blow your mind. Download the Excel file here: www.myonlinetraininghub.com/5...
Chapters:
0:00 How to use the INDEX Function
1:00 1. Row_Num argument quirk
1:32 2. Returning a Range
3:47 3. Return a Whole Column/Row
5:04 4. Operators
7:14 5. Referencing Non-contiguous Ranges
View my comprehensive courses: www.myonlinetraininghub.com/
Connect with me on LinkedIn: / myndatreacy
Негізгі бет Excel INDEX Function - 5 Secret Features - do you know them all?
Пікірлер: 126