MAKEARRAY allows you to easily generate an array (range) of values. The first two arguments are the number of rows and columns, and further should specify the expression within which the calculation is performed using the LAMBDA function. This function is also dynamic in nature because it does not return a single value but a range in accordance with the given dimensions.
What is the most common problem for programmers and report makers? Certainly, it is a lack of adequate information they need to launch the report and see if it works. Data can be entered manually. But hey: imagine yourself to manually enter 100,000 records!?! This article demonstrates simple techniques to create tables with data to test the most demanding reports.
Randomly generated numbers are most often used to generate data that we want to use to test some reports. Once upon a time, they were obtained by taking over the system time, so they would take a hundred or a thousandth of a second as a random number. Today, probably every program language has functions for generating random numbers, including Excel. For this purpose, the functions RAND and RANDBETWEEN are used …