M
Marie1uk
Hi,
I am looking to find a function that can assign a set of random values
to a column. For example if I have a list of names I want the
spreadsheet to be able to churn out a random value for the following
list,
3a 3b 3c 4a 4b 4c 5a 5b 5c
Name Random Value
M. Hardy 4a
G. Dodd 5b
B, Smith 3b
The list needs to be able to be customized right up to 7a to allow for
future expansion.
Many thanks in advance,
Marie
I am looking to find a function that can assign a set of random values
to a column. For example if I have a list of names I want the
spreadsheet to be able to churn out a random value for the following
list,
3a 3b 3c 4a 4b 4c 5a 5b 5c
Name Random Value
M. Hardy 4a
G. Dodd 5b
B, Smith 3b
The list needs to be able to be customized right up to 7a to allow for
future expansion.
Many thanks in advance,
Marie