Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
RANDBETWEEN problems
I am having problems with generating true random choices in Excel2007.
Hopefully this lines up pretty close. Columns & rows contain: M N O P 01 02 A a 0 ( 03 B b 1 ) 04 C c 2 - 05 D d 3 = 06 E e 4 [ 07 F f 5 ] 08 G g 6 09 H h 7 10 I i 8 11 J j 9 12 K k 13 L l 14 M m 15 N n 16 O o 17 P p 18 Q q 19 R r 20 S s 21 T t 22 U u 23 V v 24 W w 25 X x 26 Y y 27 Z z Lets say in each cell Q1...X1 I have the following formula: =INDEX($M:$P,RANDBETWEEN(1,COUNTA($M2:$P27)),RANDB ETWEEN(1,4)) which is supposed to generate a random choice in each of the cells. And combining the output in Q1&R1&....&X1 it returns a Passphrase = 000000 The problem is that there is a constant choice of 0 in the generated passphrase multiple times and a repetition of 000000 every dozen or so hits of the F9 key. For Example: Hiting F9 01 = 000000 02 = 000A0O 03 = 00000F 04 = 01S00d 05 = 006000 06 = n00000 07 = 00S0f0 08 = 0000r9 09 = 000002 10 = G00000 11 = z0A000 12 = 000000 Which leads me to believe RANDBETWEEN isn't working correctly as it seems to choose the 53rd position [ 0 ] alot. I hit the F9 repeatedly and it still comes up with this predictible outcome. Is there another method of truly getting a random choice in each output cell? Thanks, Phil |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
RANDBETWEEN | Excel Worksheet Functions | |||
Randbetween | Excel Discussion (Misc queries) | |||
RANDBETWEEN | Excel Worksheet Functions | |||
Randbetween | Excel Discussion (Misc queries) | |||
randbetween gives ?NAME | Excel Discussion (Misc queries) |