Welcome Guest
Log In | Register )
You last visited January 20, 2017, 12:55 pm
All times shown are
Eastern Time (GMT-5:00)

Help In Excel

Topic closed. 5 replies. Last post 9 years ago by winsumloosesum.

Page 1 of 1
PrintE-mailLink
Avatar
Michigan
United States
Member #59
November 10, 2000
380 Posts
Offline
Posted: April 26, 2008, 8:04 am - IP Logged

How does one find a 4 digit number in a group of numbers
that are listed in a row in excel????? What is the formula ????

Example find out how many times 1234 came out in the past
numbers????? Can one also get how manytimes the 4 digit
number came out in different ways like 4321 --  2314  ETC----

2 7 8 8
7 2 8 6
4 4 7 2
5 1 5 2
4 0 2 7
0 7 6 1
3 6 9 9
7 0 0 1
7 9 5 8
9 9 5 6
8 8 4 4
0 8 2 0
8 7 7 2
1 8 4 0
2 7 5 2
7 0 6 0
2 4 8 4
8 0 9 2
8 2 6 0
9 7 5 9
1 3 6 2
1 7 6 1
8 9 6 2
2 5 4 9
2 4 0 1
6 3 0 2
0 3 2 9
4 7 0 5
5 9 9 7
9 1 5 0
0 2 9 7
Learning excel myself-----Butt need help---
Also do the numbers listed have to be in separate rows or
Together in one row in excel ????? 1-2-3-4  or 1234  ??
Thank you for you time and helping out---
Bob

    winsumloosesum's avatar - Lottery-060.jpg
    Pennsylvania
    United States
    Member #2218
    September 1, 2003
    5396 Posts
    Offline
    Posted: April 26, 2008, 10:36 am - IP Logged

    How does one find a 4 digit number in a group of numbers
    that are listed in a row in excel????? What is the formula ????

    Example find out how many times 1234 came out in the past
    numbers????? Can one also get how manytimes the 4 digit
    number came out in different ways like 4321 --  2314  ETC----

    2 7 8 8
    7 2 8 6
    4 4 7 2
    5 1 5 2
    4 0 2 7
    0 7 6 1
    3 6 9 9
    7 0 0 1
    7 9 5 8
    9 9 5 6
    8 8 4 4
    0 8 2 0
    8 7 7 2
    1 8 4 0
    2 7 5 2
    7 0 6 0
    2 4 8 4
    8 0 9 2
    8 2 6 0
    9 7 5 9
    1 3 6 2
    1 7 6 1
    8 9 6 2
    2 5 4 9
    2 4 0 1
    6 3 0 2
    0 3 2 9
    4 7 0 5
    5 9 9 7
    9 1 5 0
    0 2 9 7
    Learning excel myself-----Butt need help---
    Also do the numbers listed have to be in separate rows or
    Together in one row in excel ????? 1-2-3-4  or 1234  ??
    Thank you for you time and helping out---
    Bob

    Bob,

    What state drawings(s) are you interested in.

      Avatar
      Michigan
      United States
      Member #59
      November 10, 2000
      380 Posts
      Offline
      Posted: April 26, 2008, 1:28 pm - IP Logged

      Forgot to put my state down-----

      We are from Michigan

      Bob

        winsumloosesum's avatar - Lottery-060.jpg
        Pennsylvania
        United States
        Member #2218
        September 1, 2003
        5396 Posts
        Offline
        Posted: April 26, 2008, 4:08 pm - IP Logged

        Forgot to put my state down-----

        We are from Michigan

        Bob

        Bob,

        Below is a link to download a Pick 4 Excel file.

        http://www.badongo.com/file/9060876

         

        The data file contains Connecticut Midday Pick 4.

        I can enter Michigan Pick 4 draws in a new Excel file.

        Not sure if you separate Midday and Evening draws or combine them.

        Let me know what you want.

        If you have a complete Pick 4 draw file that you can send would be better.

          Avatar
          Michigan
          United States
          Member #59
          November 10, 2000
          380 Posts
          Offline
          Posted: April 26, 2008, 6:22 pm - IP Logged

          Hi  Winsumloosesum---

           

          Can I send you a file in your private e-mailbox????

            winsumloosesum's avatar - Lottery-060.jpg
            Pennsylvania
            United States
            Member #2218
            September 1, 2003
            5396 Posts
            Offline
            Posted: April 26, 2008, 9:13 pm - IP Logged

            Bob,

            Below is the link for Michigan Pick 4 Excel file:

            http://www.badongo.com/file/9063707