| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
random numbers
You could try this.... put this formula in A1 copied down to A15 =RAND() put this formula in B1 copied down to B15 =RANK(A1,A$1:A$15) B1:B15 gives 1 to 15 in random order, hit F9 to re-generate, hide column A if you wish -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=515144 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert random numbers to text.. | Excel Worksheet Functions | |||
| Random Numbers | Excel Discussion (Misc queries) | |||
| random numbers from a data of numbers? | Excel Worksheet Functions | |||
| Random Assignment of Numbers | Excel Worksheet Functions | |||
| Random list (1-45) without repeating numbers? | Excel Worksheet Functions | |||
Threaded Mode
