O
Ole Sauffaus
I am building a "name-generator" in the following fashion:
I have 3 columns where each cell has a "text-sniblet" like this:
A | B | C
mi | cro | soft
na | vi | sion
su | per | man
.... etc...
Now I want to reference one random cell from column A, one from B
and one from C, and combine them to a new name.
My problem is now, how do I reference a random cell?
I have tried with modifying standard references like =R[X]C[-4] ...
where X are supposed to be random between 2 and 52... My resulting
reference dosn't seem to be acknowledged:
=R[ROUND(RAND()*50+2;0)]C[-4]
Can anybody help me with this?... thanks in advance.
I have 3 columns where each cell has a "text-sniblet" like this:
A | B | C
mi | cro | soft
na | vi | sion
su | per | man
.... etc...
Now I want to reference one random cell from column A, one from B
and one from C, and combine them to a new name.
My problem is now, how do I reference a random cell?
I have tried with modifying standard references like =R[X]C[-4] ...
where X are supposed to be random between 2 and 52... My resulting
reference dosn't seem to be acknowledged:
=R[ROUND(RAND()*50+2;0)]C[-4]
Can anybody help me with this?... thanks in advance.