Reference a random cell... how to?

[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.

 

[Arvi Laanemets]

Hi

With your 'sniblets' in range A1:C3

=INDEX(A1:C3,RANDBETWEEN(1,3),1) & INDEX(A1:C3,RANDBETWEEN(1,3),2) &
INDEX(A1:C3,RANDBETWEEN(1,3),3)

(you must have Analysis-Toolpack to be installed to use RANDBETWEEN
function)

 

[Ole Sauffaus]

Hi again

Thanks for your answer... But are there any way to do this without the
Analysis-toolpack?

I am working on Mac OSX, and the f****** installer won't run without a
Classic environment.

-----Original Message-----
Hi

With your 'sniblets' in range A1:C3

=INDEX(A1:C3,RANDBETWEEN(1,3),1) &

INDEX(A1:C3,RANDBETWEEN(1,3),2) &

INDEX(A1:C3,RANDBETWEEN(1,3),3)

(you must have Analysis-Toolpack to be installed to use RANDBETWEEN
function)


--
Arvi Laanemets
(When sending e-mail, use address arvil<At>tarkon.ee)

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.

.

 

[Arvi Laanemets]

Hi

=INT(RAND()*3+0.99)
can do instead
=RANDBETWEEN(1,3)


--
Arvi Laanemets
(When sending e-mail, use address arvil<At>tarkon.ee)

Hi again

Thanks for your answer... But are there any way to do this without the
Analysis-toolpack?

I am working on Mac OSX, and the f****** installer won't run without a
Classic environment.

-----Original Message-----
Hi

With your 'sniblets' in range A1:C3

=INDEX(A1:C3,RANDBETWEEN(1,3),1) &

INDEX(A1:C3,RANDBETWEEN(1,3),2) &

INDEX(A1:C3,RANDBETWEEN(1,3),3)

(you must have Analysis-Toolpack to be installed to use RANDBETWEEN
function)


--
Arvi Laanemets
(When sending e-mail, use address arvil<At>tarkon.ee)

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.

.