| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Array Help - World cup pool
Hi. I have a possible array question, if in case an array is the most
appropriate. I have a persons team selections that will proceed to second round in sheet1( A1,B1,C1,D1). If any of the persons team selection matches my worksheet with my games stats(sheet2) than give them 10 pts. Format of the games stats is: Second round team vs. team M1 Q1 M2 Q2 M3 Q3 So if any of the persons selection in Sheet1(a1,b1,c1,d1) matches [M1:M3 OR Q1:Q3] (sheet2) than give them 10 pts. Thanks for the help Chris. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Array Help - World cup pool
Hi!
Try this: Do you mean to calculate 10 points FOR EACH MATCH? =SUMPRODUCT(--(ISNUMBER(MATCH(A1:D1,M1:M3,0))+ISNUMBER(MATCH(A1: D1,Q1:Q3,0))))*10 Biff "ChristopherH" wrote in message ... Hi. I have a possible array question, if in case an array is the most appropriate. I have a persons team selections that will proceed to second round in sheet1( A1,B1,C1,D1). If any of the persons team selection matches my worksheet with my games stats(sheet2) than give them 10 pts. Format of the games stats is: Second round team vs. team M1 Q1 M2 Q2 M3 Q3 So if any of the persons selection in Sheet1(a1,b1,c1,d1) matches [M1:M3 OR Q1:Q3] (sheet2) than give them 10 pts. Thanks for the help Chris. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Array Help - World cup pool
Sweet. That works.
Thanks, Chris Go Germany! "Biff" wrote: Hi! Try this: Do you mean to calculate 10 points FOR EACH MATCH? =SUMPRODUCT(--(ISNUMBER(MATCH(A1:D1,M1:M3,0))+ISNUMBER(MATCH(A1: D1,Q1:Q3,0))))*10 Biff "ChristopherH" wrote in message ... Hi. I have a possible array question, if in case an array is the most appropriate. I have a persons team selections that will proceed to second round in sheet1( A1,B1,C1,D1). If any of the persons team selection matches my worksheet with my games stats(sheet2) than give them 10 pts. Format of the games stats is: Second round team vs. team M1 Q1 M2 Q2 M3 Q3 So if any of the persons selection in Sheet1(a1,b1,c1,d1) matches [M1:M3 OR Q1:Q3] (sheet2) than give them 10 pts. Thanks for the help Chris. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Array Help - World cup pool
You're welcome. Thanks for the feedback!
Biff "ChristopherH" wrote in message ... Sweet. That works. Thanks, Chris Go Germany! "Biff" wrote: Hi! Try this: Do you mean to calculate 10 points FOR EACH MATCH? =SUMPRODUCT(--(ISNUMBER(MATCH(A1:D1,M1:M3,0))+ISNUMBER(MATCH(A1: D1,Q1:Q3,0))))*10 Biff "ChristopherH" wrote in message ... Hi. I have a possible array question, if in case an array is the most appropriate. I have a persons team selections that will proceed to second round in sheet1( A1,B1,C1,D1). If any of the persons team selection matches my worksheet with my games stats(sheet2) than give them 10 pts. Format of the games stats is: Second round team vs. team M1 Q1 M2 Q2 M3 Q3 So if any of the persons selection in Sheet1(a1,b1,c1,d1) matches [M1:M3 OR Q1:Q3] (sheet2) than give them 10 pts. Thanks for the help Chris. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| FIFA World Cup 2006 Office Pool | Excel Worksheet Functions | |||
| Problem with Vlookup array selection | Excel Worksheet Functions | |||
| Return Array with Array | Excel Worksheet Functions | |||
| Formula to list unique values | Excel Worksheet Functions | |||
| VBA Import of text file & Array parsing of that data | Excel Discussion (Misc queries) | |||
Linear Mode
