Trying to rank contest players without dupes

[bubbasbrew]

I have a College Bowl contest going and I want the players to see how they rank in order 1-33 with the other players in the contest. Her is my formula for the players:
=INDEX(A$1:CR$1,1,LARGE(IF($H$83:$CR$83=D89,COLUMN($H$83:$CR$83)),COUNTIF($D$89:$D89,D89))*1)
*A1-CR1 are the names of the players
*H83-CR83 are their scores
*D89-D121 is how their point are stacked in this Large Formula: =LARGE(H$83:CQ$83,F89)
*F89-F121 are just the numbers 1-33

The Formula for the Rankings is: =RANK(D89,$D$89:$D$118,0)

Now this all works but only if there are scores entered. If there is just a 0 for all of the scores, then this is what I get:

0	0	0
Zerbel, Tim	WI	0
0	0	0
0	0	0
Wheaton, Christine	TX	0

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>

The 0's should have team members names and States in them. This is what it looks like with scores in them:

Bowers, Bill	AZ	34	1
Fraize, Larry	MA	27	2
Grzanna, Troy	WI	23	3
Skinner, Phillip	GA	21	4
Bowers, Mike	FL	20	5
Ellis, Jerry	VA	19	6
Leahy, Chris	WI	18	7
Bowers, Carolyn	FL	18	7

<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>

So.........How close am I to getting this right?
Mike

 

[oldbrewer]

A1-CR1 are the names of the players
*H83-CR83 are their scores

where are the scores for people in columns A:G

 

[bubbasbrew]

A1-CR1 are the names of the players
*H83-CR83 are their scores

where are the scores for people in columns A:G

There are none.The first score starts in H. The players names start in H also but I'm not sure how to tell the formula the start looking in H so I left it at A.

 

[oldbrewer]

name	state	score	helper	helper2
player1	state1	27	0.00000001	27				>>>>>>>	player9	35	<<<<<<
player2	state2	20	0.00000002	20					player26	34
player3	state3	26	0.00000003	26					player15	34
player4	state4	26	0.00000004	26					player31	32
player5	state5	28	0.00000005	28					player23	31
player6	state6	28	0.00000006	28					player12	29
player7	state7	21	0.00000007	21					player6	28
player8	state8	25	0.00000008	25					player5	28
player9	state9	35	0.00000009	35					player1	27
player10	state10	25	0.0000001	25					player4	26
player11	state11	25	0.00000011	25					player3	26
player12	state12	29	0.00000012	29					player20	25
player13	state13	19	0.00000013	19					player18	25
player14	state14	21	0.00000014	21					player11	25
player15	state15	34	0.00000015	34					player10	25
player16	state16	19	0.00000016	19					player8	25
player17	state17	17	0.00000017	17					player25	24
player18	state18	25	0.00000018	25					player24	24
player19	state2	18	0.00000019	18					player33	23
player20	state3	25	0.0000002	25					player29	23
player21	state4	22	0.00000021	22					player27	23
player22	state5	18	0.00000022	18					player32	22
player23	state6	31	0.00000023	31					player21	22
player24	state7	24	0.00000024	24					player14	21
player25	state8	24	0.00000025	24					player7	21
player26	state9	34	0.00000026	34					player2	20
player27	state13	23	0.00000027	23					player30	19
player28	state14	18	0.00000028	18					player16	19
player29	state15	23	0.00000029	23					player13	19
player30	state16	19	0.0000003	19					player28	18
player31	state17	32	0.00000031	32					player22	18
player32	state18	22	0.00000032	22					player19	18
player33	state2	23	0.00000033	23					player17	17
		formula in cell marked >>>>>	=OFFSET($A$1,MATCH(K2,$E$2:$E$34,0),0)
		formula in cell marked <<<<<<	=LARGE($E$2:$E$34,COUNT($K$1:K1)+1)
		the helper columns make each score unique so that player names can be correctly reconciled

<colgroup><col span="3"><col><col><col span="8"></colgroup><tbody>
</tbody>