Part 2: Repeat All Products By Units Sold Frequency Distribution using Power Query

Welcome to Excel Jet Consult blog post. In this Part 2, I demo how to, “Part 2: Repeat All Products By Units Sold Frequency Distribution using Power Query.” Le’ts get started Video Sample Data We are going to use the same dataset used in the formula based solution (Part 1) as seen below Power Query Operation The first thing we […]

Continue reading

Repeat All Products By Units Sold Frequency Distribution using LET | INDEX MATCH & XLOOKUP Functions

Welcome to Excel Jet Consult blog post. In this tutorial, we are going to learn how to,”Repeal All Products By Units Sold Frequency Distribution using LET | INDEX MATCH & XLOOKUP Functions.” Let’s dive in Video   Sample Data The screenshot below shows a simple dataset that is formatted as an Excel Tables using CTRL + T keyboard shortcut. We’ve […]

Continue reading

Combining the VSTACK & TAKE Functions

Welcome to Excel Jet Consult blog post. In this blog post, I will show us how to combine the VSTACK and the TAKE Functions to stack data together. Let’s get started. SAMPLE DATA The screenshot below shows the transaction data with a handful of columns VSTACK FUNCTION The VSTACK Function appends¬†arrays vertically and in sequence to return a larger array. […]

Continue reading

Advanced SQL Query in Power Query of Excel using ODBC.Query M Function

Welcome to Excel Jet Consult blog post. In this video, I demonstrated how to write advanced SQL Query in Power Query of Excel using ODBC.Query M Function. Video Set Up ODBC Connectiviity For this operation, we are required to set up the ODBC driver on our local machine. To that, you can watch this video below: Odbc.Query The ODBC.QUERY Returns […]

Continue reading

Top Botton Nth Products by Total using VSTACK LET SEQUENCE XLOOKUP and LARGE Functions

Welcome to Excel Jet Consult blog post. In this blog post, we will learn how to calculate and return the Top Botton Nth Products by Total using VSTACK LET SEQUENCE XLOOKUP and LARGE Functions. Let’s get started. Video Sample Data The screenshot below shows the sample data with three columns. In addition, we’ve got a dropdown list data validation in […]

Continue reading