Select rows randomly

Hi

I need to make a random selection from rows. I also know how many rows has to be randomly selected or what the selection percentage must be.

I appreciate any help.

RAND FUNCTION

=RAND()

will produce a random number between 0 and 1. If you want a higher range you can use:

=RAND()*100

If you want only whole numbers you can use:

=INT(RAND()*100)

RANDBETWEEN

=RANDBETWEEN(1,500)

Will produce a random whole number between 1 and 500.

Thank you very much!

I used =rand(), sorted the list accoring to the number and then picked every 10th row from the list.