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

Excel Formula for Pick 4

Topic closed. 21 replies. Last post 4 months ago by Tialuvslotto.

Page 2 of 2
51
PrintE-mailLink
Sunglasses's avatar - nicebear
Zaperlopopotam
Belgium
Member #173932
March 26, 2016
952 Posts
Offline
Posted: August 11, 2016, 4:38 pm - IP Logged

How to create a short circuit.

    Raven62's avatar - binary
    New Jersey
    United States
    Member #17843
    June 28, 2005
    49699 Posts
    Offline
    Posted: August 11, 2016, 4:54 pm - IP Logged

    How to create a short circuit.

    https://www.lotterypost.com/help/178423

    A mind once stretched by a new idea never returns to its original dimensions!

      Sunglasses's avatar - nicebear
      Zaperlopopotam
      Belgium
      Member #173932
      March 26, 2016
      952 Posts
      Offline
      Posted: August 11, 2016, 7:51 pm - IP Logged

      href

        winsumloosesum's avatar - Lottery-060.jpg
        Pennsylvania
        United States
        Member #2218
        September 1, 2003
        5387 Posts
        Offline
        Posted: August 12, 2016, 6:28 am - IP Logged

        Or shorter version:

        =IFERROR(VLOOKUP(MAX(FREQUENCY(C1:F1,C1:F1)),{1,"NM";3,"T";4,"Q"},2,0), LOOKUP(SUM(IF(FREQUENCY(C1:F1,C1:F1)=2,1)),{1,"D";2,"DD"}))

        Control-Shift-Enter

          CARBOB's avatar - FL LOTTERY_LOGO.png
          ORLANDO, FLORIDA
          United States
          Member #4924
          June 3, 2004
          5896 Posts
          Offline
          Posted: August 12, 2016, 6:33 am - IP Logged

          I don't see anything for a consecutive.

            Tialuvslotto's avatar - Jailin
            Texas
            United States
            Member #150797
            December 31, 2013
            815 Posts
            Offline
            Posted: August 12, 2016, 7:04 am - IP Logged

            Thanks for posting the link to the original thread, Raven.  I forgot to do that!

            "There is no such thing as luck; only adequate or inadequate preparation to cope with a statistical universe."

            ~Robert A. Heinlein

              Tialuvslotto's avatar - Jailin
              Texas
              United States
              Member #150797
              December 31, 2013
              815 Posts
              Offline
              Posted: August 12, 2016, 7:08 am - IP Logged

              I'm sure there's a shorter version than this:

              =IF(SUMPRODUCT(($C1:$F1=$C1)+($C1:$F1=$D1)+($C1:$F1=$E1)+($C1:$F1=$F1))=16,"Q",IF(SUMPRODUCT(($C1:$F1=$C1)+($C1:$F1=$D1)+($C1:$F1=$E1)+($C1:$F1=$F1))=10,"T",IF(SUMPRODUCT(($C1:$F1=$C1)+($C1:$F1=$D1)+($C1:$F1=$E1)+($C1:$F1=$F1))=8,"DD",IF(SUMPRODUCT(($C1:$F1=$C1)+($C1:$F1=$D1)+($C1:$F1=$E1)+($C1:$F1=$F1))=6,"D","NM"))))

              Example: Excel 2010

              All 10,000 sets

              https://1drv.ms/u/s!AifgvyqwTTMrg0dXbAgE5Tsge_xk

              Thanks, Winsum! Again!  Appreciate the spreadsheet.

              You are the Excelmeister!

              "There is no such thing as luck; only adequate or inadequate preparation to cope with a statistical universe."

              ~Robert A. Heinlein