This should work for Excel 2007 but can't test.
To enter the formula, first select a range having a row count of the value in A1 and a column count of the value in C1 + 1, then enter
RandNos(A1,B1,C1)
then while holding both the Ctrl and Shift keys, press Enter to array-enter that formula in the whole range at once.
Of course the range size needs to change according to what's in A1 and C1, which can be irritating.
If you want, we could create a macro which would put the values in the cells instead of using a formula?
|