SOLVED

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

%3CLINGO-SUB%20id%3D%22lingo-sub-2004141%22%20slang%3D%22en-US%22%3EAutomatically%20enters%20X%20in%20A2%20when%20Random%20no.%20is%202%2C%20puts%20X%20in%20cell%20A49%20when%20random%20no.%20is%2049%2C%20etc.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2004141%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20%22X%22s%20that%20are%20entered%20in%20the%20column%20A%20will%20stay%20%22X%22%20in%20those%20different%20particular%20rows%20during%20many%20random%20numbers.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3BA%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3BB%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3BC%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20D%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20Random%20number%20in%20B1%20is%204%20...%26nbsp%3B%3C%2FP%3E%3CP%3E1%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%3DINT(RAND()*128)%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3Bexcel%20will%20then%20automatically%26nbsp%3B%3C%2FP%3E%3CP%3E2%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20put%20%22X%22%20in%20Cell%20A4%2C%20etc.%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%3C%2FP%3E%3CP%3E3%3C%2FP%3E%3CP%3E4%26nbsp%3B%20%26nbsp%3BX%3C%2FP%3E%3CP%3E5%3C%2FP%3E%3CP%3E6%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2004141%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2004387%22%20slang%3D%22en-US%22%3ERe%3A%20Automatically%20enters%20X%20in%20A2%20when%20Random%20no.%20is%202%2C%20puts%20X%20in%20cell%20A49%20when%20random%20no.%20is%2049%2C%20etc%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2004387%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F888892%22%20target%3D%22_blank%22%3E%40denamark1%3C%2FA%3E%26nbsp%3BThat%20could%20be%20in%20A1%2C%20and%20copied%20down%20to%20A128%3A%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DIF(ROW()%3D%24B%241%2C%22X%22%2C%22%22)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

 

 

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

 

 

1 Reply
best response confirmed by denamark1 (Occasional Contributor)
Solution

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

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