How can I generate 10 sites randomly from a worksheet

[Guest]

I have a spraedsheet with a large number of data. All I want is to select a
row and generate 10 sites randomly for customer service purposes. I dont want
the sites to be repeated every month.

Thanks,

 

[Frank Kabel]

Hi
not sure what you mean with 'sites' in this context. Could you give some
more information?

 

[Guest]

Hi Frank,

Thanks for your email. I have got a column which has got different site
names. I want to use this column to generate 10 random site names which I can
provide it to my customer service who uses these site names for survey. I
want to do this automatically with no duplicates of site names as the months
goes by. Hopefully I am making myself a bit clearer. Hope to hear from you
soon.

Thanks,

Irene

 

[Dave Peterson]

How about using another column.

fill it with =rand()

Sort by that column whenever you want. Give the first ten in the list after the
sort.

Recalculate, resort, and give again.

 

[Guest]

Hi Dave,

Can you be a bit clearer of what I need to do. I am not that clear on "sort
by that column whenever you want" and the rest.

Thanks,

 

[Frank Kabel]

Hi
- lets assume your names are in A1:A100
- now insert in B1:
=RAND()
and copy this formula down for all rows (down to B100)
- now select the range A1:B100, goto 'Data - sort' and choose to sort with
the second column

Now just pick the first 10 items in column A for your survey

 

[Dave Peterson]

Since =Rand() will return a random number to each of the cells in that column,
you could select your range and do Data|sort.

If you sort by that column, your data will be shuffled according to the value
returned in the =rand() cell.

Recalculating will force new values and then resorting will resequence the list.