Random selecting a row of cells

Hello,

For my Master thesis I have to simulate stock portfolios. In my database the rows stand for different assets and the collums for the returns in different years. Now I want to simulate a random portfolio and calculate the volatility of this portfolio. The first step in this is to select a row randomly, although I found out how to select a random cell in a specific area, I am not able to select a random row. Has somebody an idea how I can do this?

Gr nedvim100

maybe something like this:

=INDEX(A1:C12, RANDBETWEEN(1,12), RANDBETWEEN(1,3))

Take care about ranges.

Thanks zbor, but I want to select a row of numbers so for example in an index A1:O80 I want to select a random row and use Ax:Ox for further calculations although I'm not sure that excel is able to do this.

Can you post an example with input and desired output?

In the file you see a part of the datafile I use and a description about the calculations I want to make.

Assets can be randomly taken from 1 to 630 without repeating?

I want to select the complete row of numbers. So with the formula I select a row for example row 12 (the row is a single asset with the yearly returns of this assets for 15 years) and than again a random row for example row 20. Than for every year (collom) the average return of this two assets has to be calculated which finally results in a row of 15 numbers with the average returns of this random selected assets portfolio. The last step is calculating the standard deviation of this sequence of numbers to determine the risk of this virtual portfolio.