Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
matching numbers
Would appreciate help with this request:
I have two sets of numbers in rows: eg: 2,10,16,20,38,39,42,45 3,10,15,32,36,38,40,42 I want a function that would tell me how many in the first row match with the second row? Answer I am looking for is = 3. Thanks in advance RodJ -- RodJ |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
matching numbers
=SUM(COUNTIF($A$2:$H$2,{2,10,16,20,38,39,42,45}))
or =SUM(COUNTIF($A$2:$H$2,$A$1:$H$1)) entered with ctrl + shift & enter or =SUMPRODUCT(COUNTIF($A$2:$H$2,$A$1:$H$1)) entered normally -- Regards, Peo Sjoblom "RodJ" wrote in message ... Would appreciate help with this request: I have two sets of numbers in rows: eg: 2,10,16,20,38,39,42,45 3,10,15,32,36,38,40,42 I want a function that would tell me how many in the first row match with the second row? Answer I am looking for is = 3. Thanks in advance RodJ -- RodJ |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
matching numbers
Assume columns A,B,C,D,E,F,G,H
Assume rows 1 and 2 Put the fomula =count($A$1:$H$1,A2) in cell A3 Copy that formula to cells B3:H3 Then sum cells A3:H3 to get the total number of matches for your lottery pick. Tom |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
matching numbers
Fantastic..it worked...u have helped me for the second time today..bless you...
-- RodJ "Peo Sjoblom" wrote: =SUM(COUNTIF($A$2:$H$2,{2,10,16,20,38,39,42,45})) or =SUM(COUNTIF($A$2:$H$2,$A$1:$H$1)) entered with ctrl + shift & enter or =SUMPRODUCT(COUNTIF($A$2:$H$2,$A$1:$H$1)) entered normally -- Regards, Peo Sjoblom "RodJ" wrote in message ... Would appreciate help with this request: I have two sets of numbers in rows: eg: 2,10,16,20,38,39,42,45 3,10,15,32,36,38,40,42 I want a function that would tell me how many in the first row match with the second row? Answer I am looking for is = 3. Thanks in advance RodJ -- RodJ |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
matching numbers
Thanks very much...good guess i am building a lotto template..thank u once
again... -- RodJ "TomPl" wrote: Assume columns A,B,C,D,E,F,G,H Assume rows 1 and 2 Put the fomula =count($A$1:$H$1,A2) in cell A3 Copy that formula to cells B3:H3 Then sum cells A3:H3 to get the total number of matches for your lottery pick. Tom |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
matching numbers
"u have helped me for the second time today"
I did? Anyway, thanks for the feedback -- Regards, Peo Sjoblom "RodJ" wrote in message ... Fantastic..it worked...u have helped me for the second time today..bless you... -- RodJ "Peo Sjoblom" wrote: =SUM(COUNTIF($A$2:$H$2,{2,10,16,20,38,39,42,45})) or =SUM(COUNTIF($A$2:$H$2,$A$1:$H$1)) entered with ctrl + shift & enter or =SUMPRODUCT(COUNTIF($A$2:$H$2,$A$1:$H$1)) entered normally -- Regards, Peo Sjoblom "RodJ" wrote in message ... Would appreciate help with this request: I have two sets of numbers in rows: eg: 2,10,16,20,38,39,42,45 3,10,15,32,36,38,40,42 I want a function that would tell me how many in the first row match with the second row? Answer I am looking for is = 3. Thanks in advance RodJ -- RodJ |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
matching numbers
would need to check about 10 numbers. used the formula but need adding = sign
before checking 1 set of numbers against the 10 numbers, any ways to get round them. "RodJ" wrote: Thanks very much...good guess i am building a lotto template..thank u once again... -- RodJ "TomPl" wrote: Assume columns A,B,C,D,E,F,G,H Assume rows 1 and 2 Put the fomula =count($A$1:$H$1,A2) in cell A3 Copy that formula to cells B3:H3 Then sum cells A3:H3 to get the total number of matches for your lottery pick. Tom |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
matching upc numbers and prices | Excel Discussion (Misc queries) | |||
Matching numbers and text | Excel Worksheet Functions | |||
vlookup with not exactly matching numbers | Excel Discussion (Misc queries) | |||
matching a combination of numbers | Excel Discussion (Misc queries) | |||
matching numbers in col a and col b | Excel Worksheet Functions |