Welcome to Excel Jet Consult. In this short video tutorial, we learn how to return Top Nth Values in Excel and Azure SQL Server. Enjoy
Continue readingTag Archives: Excel
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
Modelling Using New LET Function
Welcome to Excel Jet Consult blog post. In this tutorial, we will learn about how to use the newly released LET Function for modelling. Let’s get started Definition of Function & Syntax The LET function assigns names to calculation results. This allows storing intermediate calculations, values, or defining names inside a formula. These names only apply within the scope of the LET […]
Continue reading
Advanced: Case-Sensitive EXACT Function with Double SUMPRODUCT
Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how to use what has become my favorite function in Excel – SUMPRODUCT with rarely known Case Sensitive function – EXACT. I was inquisitive minded to discover whether it is possible to sum values based on text. That led me into about 20 minutes of trying to […]
Continue reading
Delete Blank Rows without impacting non-contiguous columns
Welcome to Excel Jet Consult blog post. In this tutorial, we will learn of the hidden secret d deleting empty rows without the operation impacting the non-contiguous columns with data In the caption below, we have data in columns A to C with empty rows which we want to delete. We also have data in columns E to H which, […]
Continue reading
Office 365: Enabling Office Scripts
Welcome to Excel Jet Consult blog post. In this tutorial, we want to see how to enable Office Scripts in the Microsoft 365 Admin Center. Office Scripts allows users to automate repetitive tasks and it is currently in preview for Excel on the Web. If you’re working in an organization, you may have to contact the IT department to perform […]
Continue reading
Activate Developer Tab
Welcome to Excel Jet Consul. In this tutorial, we want to see how to activate the Developer tab. Let’s get started To activate the developer tab, right-click on any of the tabs such as Home, Insert or any other Select Customize the Ribbon In the Excel Options dialogue box, check Developer Click OK. We should be able to see the […]
Continue reading
Sort Numeric Values in PivotTable in Two Ways
Welcome to Excel Jet Consult blog post. In this tutorial, we want to learn how to sort numeric values in PivotTable in two ways. Let’s get started In the caption below, we have data to work with First Method We want to sort the Sum of Total in Descending Oder in the first PivotTable Report Click on the Account Manager […]
Continue reading
Perform VLOOKUP with Multiple Lookup Values in Three Ways
Welcome to Excel Jet Consult. In this tutorial, we will learn how to perform VLOOKUP with multiple lookup values in three ways. Let’s get started In the caption below, we have a sample data to work with Note, we have list data validation in cells F2:H2. So, we want to return the Sales Total result for Abiola David with States […]
Continue reading
Full Pyramid Clustered Column Chart Shape
Welcome to Excel Jet Consult blog post. In this tutorial, we want to learn how to format our column chart using Full Pyramid shape. Let’s get started We have a sample data as seen in the caption below Create 3-D Column Chart The column shape where the full pyramid is embedded in 3-D Column and Bar Charts. Hence, we need […]
Continue reading