Randomizing a few select strings?

  • Thread starter Thread starter newbie
  • Start date Start date
N

newbie

Does someone know how to create a randbetween function or function
that will randomize
only thru the following strings?

group 10
group 11
group 12
group 13

I would like to be able to select the number of possibilities and
select the strings? For example i might want group 10 thru group 13
which is 4 string possibilities or to have only 2 possibilities like
yes, and no.

Andrew
 
newbie said:
Does someone know how [...] randomize only thru
the following strings?
Click to expand...

There are many ways to do this. The "right" choice depends on your
requirements, which are not clear to me. Here is the simplest approach....

Suppose your strings are in A1:A10. In B1:B10, put the formula =RAND().
Then select A1:B10, and use Data > Sort (in Excel 2003) to sort column B.
That will randomize the order of column A.

If that does not meet your needs, I suggest that you clarify your
requirements, including a step-by-step description of the procedure that you
wish to follow based on what input (data) and with what outcome.


----- original message -----
 
Joe,
Hey, thanks for the help, i figured another way to do it after
thinking about it.

=IF(randbetween(1,4) =1, "Group 10", IF(RANDBETWEEN(1,4) =2, "Group
11", IF(randbetween(1,4) =3, "Group 12","Group 13")))

Thanks for posting
Andrew

newbie said:
Does someone know how [...] randomize only thru
the following strings?
Click to expand...

There are many ways to do this.  The "right" choice depends on your
requirements, which are not clear to me.  Here is the simplest approach.....

Suppose your strings are in A1:A10.  In B1:B10, put the formula =RAND().
Then select A1:B10, and use Data > Sort (in Excel 2003) to sort column B.
That will randomize the order of column A.

If that does not meet your needs, I suggest that you clarify your
requirements, including a step-by-step description of the procedure that you
wish to follow based on what input (data) and with what outcome.

----- original message -----


Does someone know how to create a randbetween function or function
that will randomize
only thru the following strings?
Click to expand...
group 10
group 11
group 12
group 13
Click to expand...
I would like to be able to select the number of possibilities and
select the strings? For example i might want group 10 thru group 13
which is 4 string possibilities or to have only 2 possibilities like
yes, and no.
Click to expand...
Andrew
Click to expand...
Click to expand...
 
newbie said:
=IF(randbetween(1,4) =1, "Group 10",
IF(RANDBETWEEN(1,4) =2, "Group 11",
IF(randbetween(1,4) =3, "Group 12","Group 13")))
Click to expand...

That construction has about a 42% probability of selecting "Group 13", 14%
for "Group 12", 19% for "Group 11" and 25% for "Group 10. I suspect that is
not the probability distribution you want. Try:

=choose(randbetween(1,4), "Group 10", "Group 11", "Group 12", "Group 13")


----- original message -----

Joe,
Hey, thanks for the help, i figured another way to do it after
thinking about it.

=IF(randbetween(1,4) =1, "Group 10", IF(RANDBETWEEN(1,4) =2, "Group
11", IF(randbetween(1,4) =3, "Group 12","Group 13")))

Thanks for posting
Andrew

newbie said:
Does someone know how [...] randomize only thru
the following strings?
Click to expand...

There are many ways to do this. The "right" choice depends on your
requirements, which are not clear to me. Here is the simplest approach....

Suppose your strings are in A1:A10. In B1:B10, put the formula =RAND().
Then select A1:B10, and use Data > Sort (in Excel 2003) to sort column B.
That will randomize the order of column A.

If that does not meet your needs, I suggest that you clarify your
requirements, including a step-by-step description of the procedure that
you
wish to follow based on what input (data) and with what outcome.

----- original message -----


Does someone know how to create a randbetween function or function
that will randomize
only thru the following strings?
Click to expand...
group 10
group 11
group 12
group 13
Click to expand...
I would like to be able to select the number of possibilities and
select the strings? For example i might want group 10 thru group 13
which is 4 string possibilities or to have only 2 possibilities like
yes, and no.
Click to expand...
Andrew
Click to expand...
Click to expand...
 
=IF(randbetween(1,4) =1, "Group 10", IF(RANDBETWEEN(1,4) =2, "Group
11", IF(randbetween(1,4) =3, "Group 12","Group 13")))
Click to expand...

Hi. Maybe...

=TEXT(RANDBETWEEN(10,13),"""Group"" 00")

= = = = = = =
HTH
Dana DeLouis



Joe,
Hey, thanks for the help, i figured another way to do it after
thinking about it.

=IF(randbetween(1,4) =1, "Group 10", IF(RANDBETWEEN(1,4) =2, "Group
11", IF(randbetween(1,4) =3, "Group 12","Group 13")))

Thanks for posting
Andrew

newbie said:
Does someone know how [...] randomize only thru
the following strings?
Click to expand...

There are many ways to do this. The "right" choice depends on your
requirements, which are not clear to me. Here is the simplest approach....

Suppose your strings are in A1:A10. In B1:B10, put the formula =RAND().
Then select A1:B10, and use Data> Sort (in Excel 2003) to sort column B.
That will randomize the order of column A.

If that does not meet your needs, I suggest that you clarify your
requirements, including a step-by-step description of the procedure that you
wish to follow based on what input (data) and with what outcome.

----- original message -----


Does someone know how to create a randbetween function or function
that will randomize
only thru the following strings?
Click to expand...
group 10
group 11
group 12
group 13
Click to expand...
I would like to be able to select the number of possibilities and
select the strings? For example i might want group 10 thru group 13
which is 4 string possibilities or to have only 2 possibilities like
yes, and no.
Click to expand...
Andrew
Click to expand...
Click to expand...
Click to expand...
 
very clever.
--
Gary''s Student - gsnu201001


Dana DeLouis said:
=IF(randbetween(1,4) =1, "Group 10", IF(RANDBETWEEN(1,4) =2, "Group
11", IF(randbetween(1,4) =3, "Group 12","Group 13")))
Click to expand...

Hi. Maybe...

=TEXT(RANDBETWEEN(10,13),"""Group"" 00")

= = = = = = =
HTH
Dana DeLouis



Joe,
Hey, thanks for the help, i figured another way to do it after
thinking about it.

=IF(randbetween(1,4) =1, "Group 10", IF(RANDBETWEEN(1,4) =2, "Group
11", IF(randbetween(1,4) =3, "Group 12","Group 13")))

Thanks for posting
Andrew

Does someone know how [...] randomize only thru
the following strings?

There are many ways to do this. The "right" choice depends on your
requirements, which are not clear to me. Here is the simplest approach....

Suppose your strings are in A1:A10. In B1:B10, put the formula =RAND().
Then select A1:B10, and use Data> Sort (in Excel 2003) to sort column B.
That will randomize the order of column A.

If that does not meet your needs, I suggest that you clarify your
requirements, including a step-by-step description of the procedure that you
wish to follow based on what input (data) and with what outcome.

----- original message -----



Does someone know how to create a randbetween function or function
that will randomize
only thru the following strings?

group 10
group 11
group 12
group 13

I would like to be able to select the number of possibilities and
select the strings? For example i might want group 10 thru group 13
which is 4 string possibilities or to have only 2 possibilities like
yes, and no.

Andrew
Click to expand...
Click to expand...


--
= = = = = = =
HTH :>)
Dana DeLouis
.
Click to expand...
 
Back
Top