Ranking from one sheet to another
I'm trying to rank a particular result from one sheet to a range of results
from another sheet but it is giving me an error when I do so. Here is the
formula I'm using...
=RANK(AD16,National!B16:B56,0)
I'm not sure what would be wrong with that, unless I have to factor in
another formula to indicate the range is on another sheet?
Any help is appreciated. I'm using excell 2007
|