Forum Discussion

denamark1's avatar
denamark1
Copper Contributor
Dec 19, 2020
Solved

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

    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 i...
excel
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Dec 19, 2020

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

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

     

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Dec 19, 2020

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

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

 

Resources