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.



isankar wrote:

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,

"Dave Peterson" wrote:

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.

isankar wrote:

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

"Frank Kabel" wrote:

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

--
Regards
Frank Kabel
Frankfurt, Germany

isankar wrote:
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,




--

Dave Peterson


--

Dave Peterson