Shuffle Data using Dynamic Arrays

Introduction Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how to use Sortby and Randarray Dynamic Arrays to shuffle dataset in Microsoft Excel. Let’s get started. Video Do watch the video below. Share, like, comment and subscribe Sample Data In the caption below, we have the sample data showing records for Order Date all through […]

Continue reading

MID and SEARCH Text Functions Inside SUMIFS plus List Data Validation

Welcome to Excel Jet Consult blog post. In this Excel tutorial, we learn how to use MID & SEARCH Text Functions inside SUMIFS plus Data Validation to create a dynamic report. If you enjoy the video and tutorial, like, share, comment and subscribe to the YouTube channel. Video Sample Data In the caption below, we have Sales Data formatted as […]

Continue reading