Ranking ever other row descending order with criteria of ignoring blanks and "100"

[JJHowell]

I'm trying to rank every other row, descending order with the criteria of ignoring blanks and the value "100"

I got this far:
=IF(E2=100,"",IF(MOD(ROW(E2)-ROW(E$2),2),"",SUMPRODUCT(--(MOD(ROW(E$2:E$21)-ROW(E$2),2)=0),--(E2>E$2:E$21))+1))
<!--[if !supportLineBreakNewLine]-->
it's ignoring 100's like it should and rankingin descending order like it should, but it's still counting blanks to calculaterank and I can't seem to fix it. It works if I adjust to the correct number ofrows with teams, but I was hoping I could set this up to use as a templatewhere we could enter random numbers of teams without having to adjust theformula each time since this will be used by non excel peoples.
<!--[if !supportLineBreakNewLine]-->
<!--[endif]--><!--[endif]-->What it's doing now is column 4 'rank'. Column 5 'desired rank' is what I'm really hoping for!

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]team[/TD]
[TD]name[/TD]
[TD]time[/TD]
[TD]rank[/TD]
[TD]desired rank[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]mike[/TD]
[TD]7.99[/TD]
[TD]7[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]tate[/TD]
[TD]7.99[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]logan[/TD]
[TD]8.05[/TD]
[TD]8[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]kate[/TD]
[TD]8.05[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]bryce[/TD]
[TD]100[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]josie[/TD]
[TD]100[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]teag[/TD]
[TD]23.57[/TD]
[TD]9[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]jerron[/TD]
[TD]23.57[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD][/TD]
[TD][/TD]
[TD]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD][/TD]
[TD][/TD]
[TD]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD][/TD]
[TD][/TD]
[TD]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD][/TD]
[TD][/TD]
[TD]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD][/TD]
[TD][/TD]
[TD]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD][/TD]
[TD][/TD]
[TD]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


thanks in advance.
****** id="cke_pastebin" style="position: absolute; top: 173px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]7.99[/TD]
[/TR]
</tbody>[/TABLE]
</body>

 

[Aladin Akyurek]

Looks like... In F2 control+shift+enter, not just enter, and copy down:

=IF(E2=100,"",IF(MOD(ROW(E2)-ROW(E$2),2),"",SUM(IF(E2>IF(FREQUENCY(IF(ISNUMBER($E$2:$E$9),MATCH($E$2:$E$9,$E$2:$E$9,0)),ROW($E$2:$E$9)-ROW($E$2)+1),$E$2:$E$9),1))+1))