Link to home
Start Free TrialLog in
Avatar of mr_bungle89
mr_bungle89

asked on

Randomise in excel

Hi

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 -

Excellent
Very Good
Satisfactory
Very Poor
Unacceptable

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?
Avatar of Eirman
Eirman
Flag of Ireland image

I'm somewhat confused ... What's the difference between "response" and "Selection" ?
ASKER CERTIFIED SOLUTION
Avatar of Faustulus
Faustulus
Flag of Singapore image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial