Pick one activity from a list and keep the choice even after the worksheet recalculates. Draw a row number, look up the prompt and record the two results together.

Draw a position from four entries

Enter Map, Sketch, Sort and Label in A2:A5. In C2 enter =RANDBETWEEN(1,ROWS(A2:A5)). In D2 enter:

=INDEX(A2:A5,C2)

If the draw is 3, the prompt is Sort. This is an example outcome. The next recalculation may draw a different row.

The random position is between 1 and 4, and INDEX returns Sort when the draw is 3.

Illustrated possible draw. Keep all four list rows populated.

Paste the accepted position and text as values

Copy C2:D2 together and use Paste Values in your record area. Check that the cells are values and the position matches the prompt you accepted. Keep the text with the position, because a reordered source list may give the same position a different meaning. For a draw that needs an audit trail, record the source list and selection method as well.

The position 3 and prompt Sort are copied together into the permanent record.

Illustrated fixed record. Check the pasted cells contain values and agree with the accepted draw.

Ulet steps for pasting formula results as values

Microsoft’s RANDBETWEEN function reference