Insert Name Define

Name: RngF
Refersto: =Offset(Sheet1!$F$1,1,0,CountA(Sheet1!$F:$F$)-1,1)

Add button

Name: RngJ
Refersto: =Offset(Sheet1!$F$1,1,4,CountA(Sheet1!$F:$F$)-1,1)
Add Button

then replace rngF for $F$2:$F$122 and rngJ for $J$2:$J$122


--
Regards,
Tom Ogilvy

"sa02000" wrote in
message ...

So, I am using this formula to creat a dummy column and then rank that
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 a
way to change the no. of rows automatically. I wouldn't mind a macro if
thats what it takes. No. of rows that varies here is 122 in above
formula.
I have column B that I can may be use to get the no. of rows with
data......

Thanks for help. Jay


--
sa02000
------------------------------------------------------------------------
sa02000's Profile:
http://www.excelforum.com/member.php...o&userid=27747
View this thread: http://www.excelforum.com/showthread...hreadid=533404