Split text into expanded array using Excel EXPAND function
Here, we will learn how to use the Excel dynamic array function: EXPAND. Later, we will also learn how to split text into expanded array using EXPAND and TEXTSPLIT.
Filter and exclude columns using Excel SORT, TAKE and CHOOSECOLS
Here, we will learn how to filter and exclude columns using the Excel SORT, TAKE and CHOOSECOLS functions in one formula.
Remove last n rows using Excel TAKE function
Here, we will learn how to use the Excel dynamic array function: TAKE. Later, we will also learn how to remove the last n rows using TAKE.
Convert horizontal data to vertical using Excel WRAPCOLS and TOROW
Here, we will learn how to convert horizontal data to vertical using the Excel WRAPCOLS and TOROW functions in one formula.
Combine multiple lists into single list using Excel WRAPROWS and TOCOL
Here, we will learn how to combine multiple lists into a single list using the Excel WRAPROWS and TOCOL functions in one formula.
- Go to the previous page
- 1
- …
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- …
- 16
- Go to the next page