GitHub

This code creates a VBA function to select a random element of an array, weighted by an array of weights or frequencies.

The idea for this code was developed a few years ago while working as an auditor for an insurance multinational. That time, we were highly dependant of bult-in excel solutions for selecting samples.
TechRepublic

Use an Excel array function to create an AverageIf function

Use an Excel array function to create an AverageIf function Your email has been sent Excel doesn't have a built-in AVERAGEIF() function, but you can still average values, conditionally. Excel has ...
TechRepublic

How to use Microsoft 365’s dynamic array function SEQUENCE() to create a list of dates in Excel

How to use Microsoft 365’s dynamic array function SEQUENCE() to create a list of dates in Excel Your email has been sent Image: PixieMe/Shutterstock Must-read Windows coverage CrowdStrike Outage ...