Automatically enters X in A2 when Random no. is 2, puts X in cell A49 when random no. is 49, etc.

[denamark1]

The "X"s that are entered in the column A will stay "X" in those different particular rows during many random numbers.

     A                 B             C        D        Random number in B1 is 4 ... 

1        =INT(RAND()*128)                    excel will then automatically 

2                                                          put "X" in Cell A4, etc.     

3

4   X

5

6

[#2 · Accepted solution]

@denamark1 That could be in A1, and copied down to A128:

=IF(ROW()=$B$1,"X","")