Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Col A1=0, A2=2 etc down to A91=90
Col B1=RAND() etc down to B91=RAND() D1=INDEX($A$2:$A$92,RANK(B2,$B$2:$B$92)) I press F9 until 0(zero) appears (in D1) then: I press F9 (once) and a single random number (1-90) appears (in D1) A normal, commercial, random selector (when pressing the start button) visually revolves through all numbers (for several seconds) before stopping, having selected a number. Question: What do I need to add to D1 (above) to make it do the same? I know it can be done, but it has got me beaten. Please advise. -- Regards, John |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
harder than i thought | Excel Discussion (Misc queries) | |||
Stop / Pause a Macro using Pause button | Excel Programming | |||
Don't think it's possible, but I thought I would ask. | Excel Worksheet Functions | |||
On second thought ... | New Users to Excel | |||
thought process | Excel Programming |