I need to count the head to head results in a poker league. There are 7
players and the league works with points being allocated for all
places. I am interested in only the winner and second place. I want to
count all the final (tournament poker format games work on a knockout
basis until 2 players are left ot play for first place) head to head
results for each player against every other player. The spreadsheet is
set out like a table with names in the leftmost column and then each
games results in the adjoining column. Next to each name is the points
they got for that game. I need to count each time a players get 10
points and match them to 7 point name for each game. This will give me
the number of head to head wins that play has against an apponent. See
image for layout of league. I may need to do a number of interim
formulas to get the final results - thank you.


+-------------------------------------------------------------------+
|Filename: poker league comp 1.jpg |
|Download: http://www.excelforum.com/attachment.php?postid=5199 |
+-------------------------------------------------------------------+

--
sharkh
------------------------------------------------------------------------
sharkh's Profile: http://www.excelforum.com/member.php...o&userid=37526
View this thread: http://www.excelforum.com/showthread...hreadid=571723

How about posting the workbook?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"sharkh" wrote in
message ...

I need to count the head to head results in a poker league. There are 7
players and the league works with points being allocated for all
places. I am interested in only the winner and second place. I want to
count all the final (tournament poker format games work on a knockout
basis until 2 players are left ot play for first place) head to head
results for each player against every other player. The spreadsheet is
set out like a table with names in the leftmost column and then each
games results in the adjoining column. Next to each name is the points
they got for that game. I need to count each time a players get 10
points and match them to 7 point name for each game. This will give me
the number of head to head wins that play has against an apponent. See
image for layout of league. I may need to do a number of interim
formulas to get the final results - thank you.


+-------------------------------------------------------------------+
|Filename: poker league comp 1.jpg |
|Download: http://www.excelforum.com/attachment.php?postid=5199 |
+-------------------------------------------------------------------+

--
sharkh
------------------------------------------------------------------------
sharkh's Profile:
http://www.excelforum.com/member.php...o&userid=37526
View this thread: http://www.excelforum.com/showthread...hreadid=571723

Here is the file, all current formulas are pretty straight forward, I
have had a go at doing the next few steps in approx cell AO20ish. hope
you can help.


+-------------------------------------------------------------------+
|Filename: Kal's Poker League.zip |
|Download: http://www.excelforum.com/attachment.php?postid=5220 |
+-------------------------------------------------------------------+

--
sharkh
------------------------------------------------------------------------
sharkh's Profile: http://www.excelforum.com/member.php...o&userid=37526
View this thread: http://www.excelforum.com/showthread...hreadid=571723