LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Brad
 
Posts: n/a
Default Counting question


There are 44 players on 11 tables - people are moving around - What I would
like to know is who has played with whom - example from round 1 and 2
(detail below)

Player 1 has played with 12, 23, 34, 21, 25, and 44.
Player 12 has played with 1, 23, 34, 3, 27, and 35.

How can I do this - By the way players 1 - 11 can move (for this example I
kept them fixed?

Thanks in advance.

Round 1
1 2 3 4 5 6 7 8 9 10 11
12 13 14 15 16 17 18 19 20 21 22
23 24 25 26 27 28 29 30 31 32 33
34 35 36 37 38 39 40 41 42 43 44

Round 2
1 2 3 4 5 6 7 8 9 10 11
21 22 12 13 14 15 16 17 18 19 20
25 26 27 28 29 30 31 32 33 23 24
44 34 35 36 37 38 39 40 41 42 43

Round 3
1 2 3 4 5 6 7 8 9 10 11
19 20 21 22 12 13 14 15 16 17 18
27 28 29 30 31 32 33 23 24 25 26
43 44 34 35 36 37 38 39 40 41 42

Round 4 1 2 3 4 5 6 7 8 9 10 11
17 18 19 20 21 22 12 13 14 15 16
29 30 31 32 33 23 24 25 26 27 28
42 43 44 34 35 36 37 38 39 40 41

Round 5 1 2 3 4 5 6 7 8 9 10 11
15 16 17 18 19 20 21 22 12 13 14
31 32 33 23 24 25 26 27 28 29 30
41 42 43 44 34 35 36 37 38 39 40

Round 6 1 2 3 4 5 6 7 8 9 10 11
13 14 15 16 17 18 19 20 21 22 12
33 23 24 25 26 27 28 29 30 31 32
40 41 42 43 44 34 35 36 37 38 39

Round 7 1 2 3 4 5 6 7 8 9 10 11
22 12 13 14 15 16 17 18 19 20 21
24 25 26 27 28 29 30 31 32 33 23
39 40 41 42 43 44 34 35 36 37 38

Round 8 1 2 3 4 5 6 7 8 9 10 11
20 21 22 12 13 14 15 16 17 18 19
26 27 28 29 30 31 32 33 23 24 25
38 39 40 41 42 43 44 34 35 36 37

Round 9 1 2 3 4 5 6 7 8 9 10 11
18 19 20 21 22 12 13 14 15 16 17
28 29 30 31 32 33 23 24 25 26 27
37 38 39 40 41 42 43 44 34 35 36

Round 10 1 2 3 4 5 6 7 8 9 10 11
16 17 18 19 20 21 22 12 13 14 15
30 31 32 33 23 24 25 26 27 28 29
36 37 38 39 40 41 42 43 44 34 35

Round 11 1 2 3 4 5 6 7 8 9 10 11
14 15 16 17 18 19 20 21 22 12 13
32 33 23 24 25 26 27 28 29 30 31
35 36 37 38 39 40 41 42 43 44 34



 
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
Counting Question Metalteck Excel Discussion (Misc queries) 1 June 21st 05 09:01 PM
Counting rows of blanks across certain columns crossingboston New Users to Excel 1 May 26th 05 05:20 PM
Counting and Summing Drew Excel Discussion (Misc queries) 3 May 5th 05 04:44 PM
Hints And Tips For New Posters In The Excel Newsgroups Gary Brown Excel Worksheet Functions 0 April 15th 05 05:47 PM
Counting question Carl Excel Discussion (Misc queries) 11 March 11th 05 09:28 PM


All times are GMT +1. The time now is 04:30 AM.

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

About Us

"It's about Microsoft Excel"