Welcome Guest
Log In | Register )
You last visited January 23, 2017, 11:43 am
All times shown are
Eastern Time (GMT-5:00)

Need an excel routine for comparing numbers from row to row

Topic closed. 6 replies. Last post 8 years ago by Elizabeth03.

Page 1 of 1
31
PrintE-mailLink
MillionsWanted's avatar - 24Qa6LT

Norway
Member #9517
December 10, 2004
1281 Posts
Offline
Posted: January 11, 2009, 11:02 pm - IP Logged

Imagine I got a bunch of numbers in the first row and the same amount of numbers in the second row

What I need is a routine in a cell next to row number two which check which numbers in row two is the same as the ones in row one and count them.

I am going to use this routine for a possible KENO system. I can imagine a lot of the same numbers picked in the draw yesterday also appear in todays draw.

    Avatar
    New Member

    United States
    Member #69578
    January 12, 2009
    1 Posts
    Offline
    Posted: January 12, 2009, 3:24 pm - IP Logged

    I use a =IF(OR(firstrowis true,second true),"X","") and then I count all the Xs. That probably doesn't make sense....

      haveagreatday!'s avatar - wired shell.jpg
      New Member
      Fairfax, VA
      United States
      Member #68163
      December 14, 2008
      15 Posts
      Offline
      Posted: January 30, 2009, 3:49 pm - IP Logged

      I'd use the if statement above and also the countif function.

      There is a video on youtube, look for Excel Magic Trick #180 for the countif function.

        aspire's avatar - terlion
        New Member
        Taipei
        Taiwan
        Member #70314
        January 29, 2009
        2 Posts
        Offline
        Posted: February 20, 2009, 5:05 am - IP Logged

        Let's say your first row has numbers in cells A1 to T1, your second row has numbers in cells A2 to T2, your formula in cell U2 should be = SUM(COUNTIF(A1:T1,A2:T2)). Then hit Ctrl-Shift-Enter to finish. Your formula should look like this {SUM(COUNTIF(A1:T1,A2:T2))}

          MillionsWanted's avatar - 24Qa6LT

          Norway
          Member #9517
          December 10, 2004
          1281 Posts
          Offline
          Posted: February 22, 2009, 7:10 pm - IP Logged

          Thanks. I will test your suggestions.

            Elizabeth03's avatar - cat anm.gif
            Nova Scotia
            Canada
            Member #9934
            December 27, 2004
            891 Posts
            Offline
            Posted: February 22, 2009, 7:13 pm - IP Logged

            I play Atlantic Keno in Canada, I can't play more than 2 combinations per draw, as it would get expensive; haven't won much yet so far.. It is a interesting, challenging game for sure..

             

            Sad Wavey

              Elizabeth03's avatar - cat anm.gif
              Nova Scotia
              Canada
              Member #9934
              December 27, 2004
              891 Posts
              Offline
              Posted: February 23, 2009, 7:53 am - IP Logged

              good morning everyoneCoffee