So, I am using this formula to creat a dummy column and then rank tha
dummy column to get my ranking correctly.

=IF(F2=1000,RANK(F2,$F$2:$F$122,0)+RANK(J2,$J1:$J $122,0)/100,RANK(J2,$J$2:$J$122,0)+RANK(F2,$F$2:$F$122,0)/1000+COUNTIF($F$2:$F$122,"=1000"))

Now my problem is, my no. of rows changes very frequently...is there
way to change the no. of rows automatically. I wouldn't mind a macro i
thats what it takes. No. of rows that varies here is 122 in abov
formula.
I have column B that I can may be use to get the no. of rows wit
data......

Thanks for help. Ja

--
sa0200
-----------------------------------------------------------------------
sa02000's Profile: http://www.excelforum.com/member.php...fo&userid=2774
View this thread: http://www.excelforum.com/showthread.php?threadid=53340