Sounds like some kind of lottery excercise. Unless order is relevant, your
approach does not model anything pertinent to the lottery.
also, randbetween doesn't generate unique random numbers, so this also
wouldn't match a lottery.
--
Regards,
Tom Ogilvy
"gregaw " wrote in message
...
Hi
I'm trying to perform the following procedure and hopefully someone can
help:
In cells A1..F1 in Excel I have a function =randbetween(1,20)
In cells G1..L1 I have the numbers 2,4,6,8,10,12
In cells A2..F2 I also have the function randbetween(1,20) and in cells
G2 to L2 I have the numbers 3,6,9,12,15,18
Each time one presses F9, the random numbers in A1..F2 will
recalculate.
What I would like to perform if possible is the following routine in
the order that follows:
(1) Recalculate the spreadsheet until the condition is met that
a1=g1,b1=h1,c1=i1,d1=j1,e1=k1 and f1=l1.
(2) Once that condition is met record in cell m1 how many times the
recalculation had to be performed until that condition was met.
(3) Also, once that condition is met paste g1..l1 over a1..f1 so that
no further random number generations will occur in a1..f1.
(4) Move the routine on to the next row (i.e. row 2) and perform the
same procedure as in A1..F1 above.
Many thanks,
Greg
---
Message posted from http://www.ExcelForum.com/