You need 12 fictional stock counts for a sorting exercise. Put a random grid in a scratch sheet so you can practice on disposable data.

Set the size and bounds in one formula

Clear B2:D5 in an empty part of the workbook and enter this in B2 in a spreadsheet that supports RANDARRAY.

=RANDARRAY(4,3,1,9,TRUE)

The first two arguments give four rows and three columns. The next two set the bounds at 1 and 9. TRUE asks for whole numbers. The drawn numbers can repeat.

The formula in B2 spills across three columns and four rows, ending at D5.

Illustrated spill. The numbers are one possible draw.

Verify the grid and save a fixed practice set

Confirm the output stops at D5 and contains 12 values. Check that every value is a whole number from 1 to 9. If the range fails to fill, check the cells in B2:D5 for existing data. Recalculation can change the values. For a fixed exercise, copy the result to another range with a values-only paste.

The check card confirms 12 whole numbers from 1 to 9 and a separate values-only snapshot.

Illustrated checklist. Validate shape and range rather than expecting the pictured values.

Microsoft’s RANDARRAY syntax and spill behavior