Need an excel routine for comparing numbers from row to rowPrev TopicNext Topic

• MillionsWanted

  

  Norway
  Member #9,517
  December 10, 2004
  1,904 Posts
  Offline
  Jan 11, 2009, 11:02 pm

  ▲▼

  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.
• mauludin

  

  United States
  Member #69,576
  January 12, 2009
  1 Post
  Offline
  Jan 12, 2009, 3:24 pm

  ▲▼

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

  

  Fairfax, VA
  United States
  Member #68,161
  December 14, 2008
  18 Posts
  Offline
  Jan 30, 2009, 3:49 pm

  ▲▼

  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

  

  Taipei
  Taiwan
  Member #70,312
  January 29, 2009
  2 Posts
  Offline
  Feb 20, 2009, 5:05 am

  ▲▼

  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

  

  Norway
  Member #9,517
  December 10, 2004
  1,904 Posts
  Offline
  Feb 22, 2009, 7:10 pm

  ▲▼

  Thanks. I will test your suggestions.
• Elizabeth03

  

  Nova Scotia
  Canada
  Member #9,934
  December 27, 2004
  1,292 Posts
  Offline
  Feb 22, 2009, 7:13 pm

  ▲▼

  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..

   

  
• Elizabeth03

  

  Nova Scotia
  Canada
  Member #9,934
  December 27, 2004
  1,292 Posts
  Offline
  Feb 23, 2009, 7:53 am

  ▲▼

  good morning everyone