As a guess your calculation mode is set to manual. Change it to automatic.
Tools - Options - Calaculation Tab
--
HTH...

Jim Thomlinson


"sa02000" wrote:


I am using simple rank formula to rank one list. So I copy this formula
=RANK(F2,$F$2:$F$123) in first cell and then double click on fill
handle to fill this formula in my whole list. But I get exact same rank
in all cells. If I click inside each cell (in the formula bar) and then
hit enter then formula seem to give the right rank instead of same
rank....but I will have to do that in all the cells to get correct
ranking....anybody has any idea why this is happening??

Thanks, Jay


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