Choosing Random Cell

I have 100 rows x 3 collumns. The columns are min, mean, max. I want excel to choose a cell randomly from each row, so lets say the first one will be either min, mean, or max. next row same thing again.

Is that possible? I'm really stuck on this, thanks

Assuming that Columns A, B, and C contain your data, and that the first row contains your headers, try...

D2, copied down:

=INDEX(A2:C2,ROUND(RAND()*(3-1)+1,0))

Hope this helps!

Originally Posted by ricta

I have 100 rows x 3 collumns. The columns are min, mean, max. I want excel to choose a cell randomly from each row, so lets say the first one will be either min, mean, or max. next row same thing again.

Is that possible? I'm really stuck on this, thanks