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 […]

Continue reading

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 […]

Continue reading

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 […]

Continue reading

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 […]

Continue reading

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 […]

Continue reading

3 Hidden Tips & Tricks You Probably Don’t Know About ADVANCED Filter

Welcome to Excel Jet Consult blog post. In this tutorial, we are going to learn about the 3 Hidden Tips & Tricks You Probably Don’t Know About ADVANCED Filter. Let’s get started Video Sample Dataset In the screenshot below, we have our sample dataset with five columns. In addition, we have a drop down list in cell M6 that contains […]

Continue reading

Author LAMBDA Custom Function using New Advanced Formula Editor

Welcome to Excel Jet Consult blog post. In this tutorial, we are going to learn about the newly released Advanced Formula Editor which is available as an Add-in the Excel Desktop, Mac and Online platforms. Let’s get started Video Advanced Formula Environment The Advanced Formula Environment allows users to create, modify, reuse and import formulas from URL and text. The […]

Continue reading

Calculate Sales Commission for Weekdays & Weekends using Power Query M Code

Welcome to Excel Jet Consult blog post. In this tutorial, we are going to learn how to calculate Sales Commission for Weekdays and Weekends using Power Query M Code. Let’s get started Video Sample Data In the caption below, we have Sales Data that is officially formatted as an Excel Table and fSalesData has be given as Table name Load Data to […]

Continue reading