Do I need to combine hlookup and countif?????

[sharkh]

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 |
+-------------------------------------------------------------------+

 

[Bob Phillips]

How about posting the workbook?

--
HTH

Bob Phillips

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

 

[sharkh]

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

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