I created a dummy column with this formula

=IF(E2>=1000,RANK(E2,$E$2:$E$122,0)+RANK(I2,$I1:$I$122,0)/100,RANK(I2,$I$2:$I$122,0)+RANK(E2,$E$2:$E$122,0)/1000+COUNTIF($E$2:$E$122,">=1000"))

and then ranked this dummy column to get my actual ranking
=RANK(K2,$K$2:$K$122,1)

I used help from this page by chris Pearson....
http://www.cpearson.com/excel/rank.htm

Thanks for all those who replied to this and other similar posts.

Jay