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,