*This blog is brought to you by the Excel Community where you can find additional blogs, extended articles and webinar recordings on a variety of Excel related topics. In addition to live training events, Excel Community members have access to a full suite of online training modules from Filtered. There is also an online forum where you can ask questions and share ideas with other community members.*

Hello all and welcome back to the Excel Tip of the Week! This time we have a Creator-level post in which we are going to kick off a new miniseries. In this miniseries we will be showing how you can build a template to do audit sampling in three different ways - with traditional Excel formulas, with VBA macros, and today's topic - how to build the template with the new dynamic arrays available in Excel for Microsoft 365.

In each of these posts, we'll be examining how the template works and explaining the formulas used in the main post. And in each, the finished product will be available to download. This first instalment is available for free on Tech News; the other two will be posted in the coming weeks in the Excel Community.

You can also view a version of this blog on YouTube: