Create a random word generator

Hello

A simple way is to create a random words table which consists of column A for word and column B for random number and sort it by column B, which yields a list of predefined words in a random order. Then you may extract the words from this ranom words table in the main table.

Something like this:

Table = name & word

A1 NAME

A2 name 1

A3 name 2

A4 name 3

A5 name 4

A6 name 5

A7 name 6

A8 name 7

A9 name 8

A10 name 9

B1 WORD

B2 =INDEX(random words::A, ROW(), 1)

B3 =INDEX(random words::A, ROW(), 1)

B4 =INDEX(random words::A, ROW(), 1)

B5 =INDEX(random words::A, ROW(), 1)

B6 =INDEX(random words::A, ROW(), 1)

B7 =INDEX(random words::A, ROW(), 1)

B8 =INDEX(random words::A, ROW(), 1)

B9 =INDEX(random words::A, ROW(), 1)

B10 =INDEX(random words::A, ROW(), 1)

Table = random words

A1 WORD

A2 word 17

A3 word 14

A4 word 18

A5 word 16

A6 word 3

A7 word 9

A8 word 11

A9 word 2

A10 word 5

A11 word 13

A12 word 6

A13 word 10

A14 word 15

A15 word 20

A16 word 12

A17 word 7

A18 word 1

A19 word 4

A20 word 8

A21 word 19

B1 RAND

B2 =RAND()

B3 =RAND()

B4 =RAND()

B5 =RAND()

B6 =RAND()

B7 =RAND()

B8 =RAND()

B9 =RAND()

B10 =RAND()

B11 =RAND()

B12 =RAND()

B13 =RAND()

B14 =RAND()

B15 =RAND()

B16 =RAND()

B17 =RAND()

B18 =RAND()

B19 =RAND()

B20 =RAND()

B21 =RAND()

Regards,

H

------

Hi Gwyn

One thing to be aware of is that Numbers recalculates automatically everytime something changes in the table.

That can lead to situations like this:

The left pair of tables show the Name/Password list after 9 names have been entered (on the left) and the current state of the sorting table (to the right).

The pair on the right show the same two tables after a new child joins the class, and her name has been added. to the list.

Oops! Everybody suddenly has a new password!

To prevent this, you need to 'freeze' the values in either the column on the right hand table containing the random numbers or in the column on the left hand table containing the passwords.

To do so, elect either column and Copy. With the column still selected, go Edit > Paste values (in Numbers 3, Edit > Paste formula results).

the password list in the left hand column will now remain stable as names are aded to that list.

Regards,

Barry