Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 33
Default Head to head

I'm trying to statistically capture head-to-head occurences in a
sports league. Out of 120 teams, I want to capture only 35 of those
teams and how many times there is a head-to-head occurence within that
pool of 35. I know the schedule will show something like "Team1 vs
Team 2" and then "Team 2 vs Team 1." If they are referring to the same
game, I only want to count it as one occurence. Does anyone have a
method or spreadsheet that can help me do this?

 
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
In over my head with calendar 8.0 Matt the wire guy Excel Worksheet Functions 2 July 22nd 07 05:08 AM
Formula. Way over my head Hicksey Excel Discussion (Misc queries) 7 August 20th 06 12:36 PM
Cant get my head around this one mbys14932 Excel Worksheet Functions 7 June 9th 06 05:23 PM
Over my head on this one... ChuckF Excel Worksheet Functions 1 April 6th 06 10:57 PM
head count on rota nick Excel Worksheet Functions 1 March 9th 05 07:39 PM


All times are GMT +1. The time now is 04:32 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"