Most Excel users know OFFSET returns a reference to a range of cells, but there are actually 8 functions that return references. Download the Excel file here: www.myonlinetraininghub.com/e...
Chapters:
0:00 OFFSET
5:47 INDEX
10:21 XLOOKUP
11:04 CHOOSE
13:27 SWITCH
14:36 IF
15:38 IFS
16:26 INDIRECT
View my comprehensive courses: www.myonlinetraininghub.com/
Connect with me on LinkedIn: / myndatreacy
Негізгі бет 8 Excel Functions that Return References - Do you know them all?
Пікірлер: 135