|
|
#3
10-16-2022, 03:47 PM
|
||||
|
||||
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? 
|
| Tags |
| excel 2007, rand, random |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Copy Random Generated Number to new Sheet | farhadj | Excel Programming | 2 | 06-02-2019 11:28 PM |
| How to insert random numbers that equal a certain number | baha | Excel | 16 | 11-24-2014 10:50 AM |
| Endnotes Generating Random Sections for Each Page | Kim Korn | Word | 7 | 08-13-2014 09:51 PM |
| Random number difficulties | ahrinn | Word | 12 | 08-01-2012 01:04 PM |
 generating a number in Word
|
John P | Word | 1 | 05-31-2012 10:29 PM |
Windows 10 
Office 2019
Threaded Mode