Random change of numbers in a single cell

[Vicky6615]

Hello Board !

I have stuck in a situation where i have 2 sheet. In 1st sheet i have stored a number from 1 - 1000 at column A i.e. (A1 : A1000).

Now what i want is to display a range of numbers in a single cell from sheet 1 to sheet 2 Randomly and vice a versa.

For Example :

In Cell A1 of Sheet 2 in want to display a number range from (11 - 60) of sheet 1 ,

In Cell B2 of sheet 2 in want to display a number range from (751 - 1000) of sheet 1.

Kindly help to fetch the solution

Thanking You,
Vikash

 

[jindon]

In Cell A1 of Sheet 2 in want to display a number range from (11 - 60) of sheet 1 ,

In Cell B2 of sheet 2 in want to display a number range from (751 - 1000) of sheet 1.

Don't understand what you want...

 

[Lewiy]

Is there a particular reason you need to select these from sheet1? You can use:

=INT(RAND()*49)+12

For a random number between 11 and 60 and

=INT(RAND()*250)+751
For a random number between 751 and 1000.