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

 

[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]...

 

[Guest]

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

 

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

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

Jay

 

[Guest]

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.