Calculate % of Grand Total using Microsoft Excel SCAN Function

Welcome to Excel Jet Consult blog post. In this Microsoft Excel video, I demo how to use the new SCAN LAMBDA Helper Function to calculate % of Grand Total. Like | Share | Subscribe Video SCAN Function The SCAN Function scans an array by applying a LAMBDA to each value and returns an array that has each intermediate value. Syntax =SCAN ([initial_value], array, […]

Continue reading

Using CHOOSE and XLOOKUP Functions to Choose & Lookup Values Across Different Workbooks

Welcome to Excel Jet Consult blog post. This Excel tutorials talks about using the CHOOSE & XLOOKUP Functions to choose and lookup values from different workbooks. Video Sample Data In the caption below, we have two different workbooks we want to work across. The first caption is about Customer Quote where we are going to use the CHOOSE & XLOOKUP […]

Continue reading

Remove Line Breaks using Power Query

In the previous video and blog post, we considered how to use FILTERXML combined with arrays of functions to remove line breaks. In this tutorial, we shall learn how to perform the same operation using the Power Query. Let’s get started. Video Do take time to watch the tutorial video and subscribe to the YouTube Channel Sample Data In the […]

Continue reading