How can I generate 10 sites randomly from a worksheet
 

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,

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,

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,

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

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

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

--
Regards
Frank Kabel
Frankfurt, Germany

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,

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