P

#### plb

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)),RANDBETWEEN(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