SUMPRODUCT and FIND Functions to Sum Case Sensitive Values

Introduction Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how to extract numbers from alphanumeric values across multiple columns and then summed. We will combination of several high-level Excel functions spanning over 600 length of characters! Let’s get started   Sample Data In the caption below, we have our sample data in columns A and […]

Continue reading

Unusual Way To Create Chart With Paste Special

Introduction Welcome to Excel Jet Consult blog post. In this tutorial, we will learn some unusual method to create any chart. Let’s get started Sample Data In the caption below, we have simple data showing Account Managers and sales for each quarters. Create Empty Column Chart To create and empty column chart Select any cell outside the data  In the Charts group […]

Continue reading

Dynamic Chart Title

Introduction Welcome to Excel Jet Consult blog post. In this tutorial, we are going to learn how to make chart title dynamic. Let’s get started Sample Data In the caption below, we have a sample data Create Chart For this example, we will create a clustered column chart. Dynamic Chart Titles works on all charts. In the Charts group of the Insert tab, […]

Continue reading

KEEPFILTERS DAX Function

Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how to use the KEEPFILTERS DAX Function to create Single and Multiple Columns Filters. Let’s get started. Definition of Function and Syntax KEEPFILRERS modifies how filters are applied while evaluating a CALCULATE or CALCULATETABLE function. The KEEPFILTERS function allows you to modify this behavior. When you use […]

Continue reading

FILTER As Alternative To VLOOKUP, INDEX MATCH & XLOOKUP Functions

Introduction Welcome to Excel Jet Consult blog post. In this blog post, we will learn how to use FILTER Dynamic Array Function to perform the same operation that lookup family functions such as VLOOKUP, INDEX MATCH and XLOOKUP will perform. Let’s get started Definition of FILTER Function & Syntax The FILTER Function filters a range or an array Syntax    […]

Continue reading