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

Question

&nbsp;&nbsp;The "X"s that are entered in the column A will stay "X" in those different particular rows during many random numbers.&nbsp;&nbsp; &nbsp; &nbsp;A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;C&nbsp; &nbsp; &nbsp; &nbsp; D&nbsp; &nbsp; &nbsp; &nbsp; Random number in B1 is 4 ...&nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; =INT(RAND()*128) &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;excel will then automatically&nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; put "X" in Cell A4, etc.&nbsp; &nbsp; &nbsp;34&nbsp; &nbsp;X56&nbsp;&nbsp;

riny_van_eekelen · Accepted Answer

denamark1&nbsp;That could be in A1, and copied down to A128:=IF(ROW()=$B$1,"X","")&nbsp;

Forum Discussion

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

1 Reply

Resources