Forum Discussion
Automatically direct values of randomly chosen cells
Hi,
I have created a row of cells that gives a random number between two values.
Beneath that row, i would like to create arow which directs the values of the collumn A in the rownumber which is randomly chosen in the row above it.
For instance:
Row 100: 25, 14, 42. etc.
Row 101: [A25], [A14], [A42] etc.
Is there an option to automatically do this?
2 Replies
Did you have the value of 25, 14, 42. etc in one cell or separated cells.
Or else show me an example.
Hi Logaraj Sekar,
These values are placed in one row. It is a row of 450 seperate random values in 450 cells located next to each other.
