# Switch from Total Sales, Average Sales & Sum of Qty using VSTACK, HSTACK and many more functions

Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how to Switch from Total Sales, Average Sales & Sum of Qty using VSTACK, HSTACK and many more functions. Let’s get started Video

# Combining TEXTBEFORE & TEXTAFTER Function with SUMIFS in Excel

Welcome to Excel Jet Consult blog post. In this tutorial, we going to learn how to combine TEXTBEFORE & TEXTAFTER Function with SUMIFS in Excel Video Sample Dataset for the First Example In the screenshot below, we have the first sample dataset which contains Full Name. So, what we wanna do is to use the new TEXTBEFORE and the TEXTAFTER […]

# VSTACK: Stack Multiple FILTERED List using Multiple Criteria in Excel

Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how to use VSTACK Function to Stack Multiple FILTERED List using Multiple Criteria in Excel. Let’s get started Video

# APPEND Data From Multiple Sheets & Get Total Row using VSTACK & HSTACK

Welcome to Excel Jet Consult blog post. In this tutorial, we shall consider additional two out of the 14 newly released function by the Microsoft Excel team. Let’s proceed Video VSTACK Function The VSTACK Function appends data to the first blank cell at the bottom of a range. Syntax =VSTACK(array1,[array2],…) The VSTACK function syntax has the following argument: array    The […]

# Brand New TEXTSPLIT, TEXTAFTER & TEXTBEFORE Functions

Welcome to Excel Jet Consult blog post. In this tutorial, we are going to look at the brand new TEXTSPLIT, TEXTAFTER & TEXTBEFORE functions. Let’s get started. Video TEXTSPLIT Function On March 16th 2022, Microsoft Excel Team released 14 brand new functions which you can read here. The TEXTSPLIT Function splits text strings by using column and row delimiters. The […]

# How SWITCH Function will make you the “Go-to Person”

Welcome to Excel Jet Consult blog post. In this tutorial, we are going to learn how to use the SWTICH and the FILTER Functions to create a dynamic report. Let’s get started Video SWITCH Function The SWITCH Function evaluates one value (called the expression) against a list of values, and returns the result corresponding to the first matching value. If there […]

# Dynamic Array FILTER by Month & Quarter

Welcome to Excel Jet Consult blog. In this tutorial, we are going to learn how to use the elegant dynamic array FILTER Function to filter dataset by Month and Quarter. Let’s get started Video Sample Data In the screenshot below, we have sample dataset for filtering by month. We are going to use the same dataset for for filtering by […]

# ADVANCED Filter Super Trick to Reorder Entire Columns without Criteria

Welcome to Excel Jet Consult blog post. In this final tutorial on ADVANCED filter, we are going to see how to reorder columns without applying any criteria. Let’s roll Video Sample Data In the screenshot below, we have the same dataset use in the previous tutorial. If you look at it closely, you will discover that the main dataset has […]