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.

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.

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



