LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ChristopherH
 
Posts: n/a
Default 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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
FIFA World Cup 2006 Office Pool Sibwhistle Excel Worksheet Functions 3 April 22nd 06 07:16 PM
Problem with Vlookup array selection Scott269 Excel Worksheet Functions 2 January 30th 06 05:29 PM
Return Array with Array Brad Excel Worksheet Functions 10 November 17th 05 06:45 PM
Formula to list unique values JaneC Excel Worksheet Functions 4 December 10th 04 12:25 AM
VBA Import of text file & Array parsing of that data Dennis Excel Discussion (Misc queries) 4 November 28th 04 10:20 PM


All times are GMT +1. The time now is 04:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"