J
Joe
I have column A generating random numbers. In column B I have values
of either true or false assigned to the random numbers in column A.
What I want to do in Column C (hopefully) is to say if column B is
true, then go back and come up with a new random number in column A
until column B becomes false.
I'll try to illustrate.
A1=Rand() B1=Flase C1=Column B is Fine
A2=Rand() B2=Flase C2=Column B is Fine
A3=Rand() B3=True C3=Since B3=true,
generate a new # in A3
until B3 becomes false
A4 =Rand() B4=False C4=Column B is Fine
I need to know how/if column C can tell column A to come up with a new
#.
of either true or false assigned to the random numbers in column A.
What I want to do in Column C (hopefully) is to say if column B is
true, then go back and come up with a new random number in column A
until column B becomes false.
I'll try to illustrate.
A1=Rand() B1=Flase C1=Column B is Fine
A2=Rand() B2=Flase C2=Column B is Fine
A3=Rand() B3=True C3=Since B3=true,
generate a new # in A3
until B3 becomes false
A4 =Rand() B4=False C4=Column B is Fine
I need to know how/if column C can tell column A to come up with a new
#.