Excel or Open office help?

Reply #4

phileight — Sun, 27 Sep 2009 23:38:14 GMT

bootleg233

basic process i would use is generate a random #'s between 1 and 4. use the random # as an index into your number, using the mid command. from your post it appears all four digits would be in 1 cell, so use your random # in a mid command to identify the position of a number.

in excel the above would look something like this:

random command

=int((rand()*4))+1 gives interger max value 4, min val 1 repeat as many time as needed in this case 4

mid command assume rand... [ More ]

Reply #3

bootleg233 — Sat, 26 Sep 2009 21:41:59 GMT

Will do

Reply #2

alsports2000 — Sat, 26 Sep 2009 17:09:28 GMT

Let me know whenever or if ever you get a response, I have been looking for something like that also for TX. Daily 4's. I am also waiting for some responses to a question a posted last week, over 800 views but no responses. Thanks. AL.

Reply #1

bootleg233 — Sat, 26 Sep 2009 14:48:23 GMT

WOW so many responces lol....

Excel or Open office help?

bootleg233 — Sat, 26 Sep 2009 00:58:19 GMT

Hey gang all you code peoples could someone tell me how or if you can get open office to random pick numbers from a set like:

1834

5946

2573

0718

What I need is like Pick 1 number from each line randomly so I end up with a set of 4 such as (1920): 1 from first line 9 from second line 2 from third line and 0 from the last line going down. Any help or pointers would be appreciated Thanks in advance.