Welcome Guest
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

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.

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

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.

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))}

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

Thanks. I will test your suggestions.

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

Nova Scotia