I am trying to generate some test data for a customer survey that I am building.
The customer can enter one of the following responses -
I want to generate some data for 1921 rows. I want excel to select any one of those entries at random. At the moment I can only randomize the order or the response and not the selection.
Can anyone help me?