Dynamically Append Tables Across Sheets using FILTERXLM

Welcome to Excel Jet Consult blog post. We previously learn how to split values into multiple columns using FILTERXLM Function. In this tutorial, we will consider how we can write a robust and easily understandable formula that will dynamically append tables across sheet sheets using the FILTERXML Function. Let’s get started Video Sample Data In the caption below, we have […]

Continue reading

SUM & COUNT Cell Color using SUMPRODUCT Function

Welcome to Excel Jet Consult blog post. In this blog post, we learn how to use the elegant SUMPRODUCT Excel Function to SUM & COUNT based on cell color. Sample Data We have a sample dataset that spans from columns A to C. In Columns B and C respectively, we have Account Manager name and the corresponding Sales Amount color-coded with unique cell color. […]

Continue reading

Generate Random List using RANDBETWEEN & FILTER Functions in Excel

Introduction Welcome to Excel Jet Consult blog post. In this tutorial, we learn about how to generate random number using the RANDBETWEEN & FILTER Functions in Excel. Let’s get started Tutorial Video You can watch the video below for more in-depth explanation. Remeber to subscribe to my YouTube channel for more videos Sample Data In the caption below, we have […]

Continue reading