Author: Kunal

Here, we will learn how to use the Excel dynamic array function: VSTACK. Later, we will also learn how to combine and sort unique arrays vertically.

Here, we will learn how to use the Excel statistical function: COUNTIF. Later, we will also learn how to count checkmarks and cross marks.

Here, we will learn how to use the Excel lookup and reference function: INDIRECT. Later, we will also learn how to find range total.

Here, we will learn how to use the Excel dynamic array function: TOROW. Later, we will also learn how to sort and extract unique values into row.

Here, we will learn how to use the Excel dynamic array function: TOCOL. Later, we will also learn how to sort and extract unique values using TOCOL.