Excel XLOOKUP and XMATCH functions
Here, we will learn how to use the Excel dynamic array functions: XLOOKUP and XMATCH.
Excel FILTER, RANDARRAY, SEQUENCE, SORT, SORTBY and UNIQUE functions
Here, we will learn how to use the Excel dynamic array functions: FILTER, RANDARRAY, SEQUENCE, SORT, SORTBY and UNIQUE.
Excel ARRAYTOTEXT and VALUETOTEXT functions
Here, we will learn how to use the Excel dynamic array functions: ARRAYTOTEXT and VALUETOTEXT.
Excel TEXTAFTER, TEXTBEFORE and TEXTSPLIT functions
Here, we will learn how to use the Excel dynamic array functions: TEXTAFTER, TEXTBEFORE and TEXTSPLIT.
Excel TOCOL, TOROW, WRAPCOLS and WRAPROWS functions
Here, we will learn how to use the Excel dynamic array functions: TOCOL, TOROW, WRAPCOLS and WRAPROWS.