Welcome Guest
Log In | Register )
You last visited December 3, 2016, 10:50 pm
All times shown are
Eastern Time (GMT-5:00)

need help in excel

Topic closed. 2 replies. Last post 10 years ago by phileight.

Page 1 of 1
PrintE-mailLink

Malaysia
Member #40236
May 30, 2006
1 Posts
Offline
Posted: January 18, 2007, 4:09 am - IP Logged

this is a formula based on drawing date,i need help to create it using excel...

the table just for 2d only

 

date                      selected number

0                          0-7-8-5

1                          1-8-9-6

2                          2-9-0-7

3                          3-0-1-8

4                          4-1-2-2

5                          5-2-3-0

6                          6-3-4-1

7                          6-3-4-1

8                          8-5-6-3

9                          9-6-7-4

e.g draw date- Jan 18,so just pick  [8]      8-5-6-3  =85,86,83,56,53,63

hope someone can solve my puzzle...

tq.

    lotterybraker's avatar - pyramid
    mississippi
    United States
    Member #34478
    March 3, 2006
    5903 Posts
    Offline
    Posted: January 19, 2007, 2:20 am - IP Logged

    remove row 6 or 7 and replace with combo 7-4-5-9 and you will have 4 vertical rows of 0-9 sequence

    "Attention all Mathematicians: Check your degree at the door because when it comes to whole numbers you are the Amateur"

      Avatar

      United States
      Member #41846
      June 23, 2006
      458 Posts
      Offline
      Posted: February 8, 2007, 7:10 pm - IP Logged

      Nagakramat

      I've looked at this a couple of times. I don't understand what you want.

      are the numbers 1 thru 9 fixed? is the 2nd column always the same?

      do you want the pairs from a given number?

      Restate your problem and you will likely get some help

       

      p8