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.

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.

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



