Ranking from one sheet to another
in [Functions]
|
Prev: =SUBSTITUTE(C4,"~?#","") will this work to remove multiple string
Next: Remove Text From AlphaNumeric
From: casdaq on 10 May 2010 19:25 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
From: p45cal on 10 May 2010 20:14
You do realise that the number in AD16 has to be one of the numbers in National!B16:B56 ? Being on a different sheet is OK. c a s d a q ; 7 2 0 8 4 4 W r o t e : > 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 -- p45cal *p45cal* ------------------------------------------------------------------------ p45cal's Profile: http://www.thecodecage.com/forumz/member.php?u=558 View this thread: http://www.thecodecage.com/forumz/showthread.php?t=201838 http://www.thecodecage.com/forumz |