this is weird

[sa02000]

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

[Jim Thomlinson]

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
>
>

[Chip Pearson]

It sounds like calculation is set to manual. Go to the Tools
menu, choose Options, then the Calculation tab. There, ensure
that Calculation is set to Automatic.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"sa02000" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>

[Andrew B]

Hi
You may need to set calculation to automatic - it appears that it is
currently on manual which won't refresh the formula results.

Andrew B

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]

Thank you all for replying. I was running a macro and turning the calculation off to make the macro go faster.

Jay

[Jim Thomlinson]

Make gosh darn sure that you use an errorhandler with any macro that toggles
the application settings...

sub Test
on error goto errorhandler
application.calculation = xlManual
'Your Code Here
Errorhandler:
application.calculation = xlAutomatic
end sub

That of course won't help you if you halt your code while debugging... Then
you just have to remember to turn it back on.
--
HTH...

Jim Thomlinson


"sa02000" wrote:

>
> Thank you all for replying. I was running a macro and turning the
> calculation off to make the macro go faster.
>
> Jay
>
>
> --
> sa02000
> ------------------------------------------------------------------------
> sa02000's Profile: http://www.excelforum.com/member.php...o&userid=27747
> View this thread: http://www.excelforum.com/showthread...hreadid=533890
>
>