Maybe (?)

{=RANK(MAX(IF(A1:A28<C1,A1:A28)),A1:A28)-1}

Jack Sons
The Netherlands


"William" schreef in bericht
...
Hi Bill

Assuming the range of numbers are in A1:A28 and the number you want a
ranking for is in cell C1 then try...
{=RANK(MAX(IF(A1:A28<C1,A1:A28)),A1:A28)}
This is an array formula so enter with Ctrl+Shift+Enter

-----
XL2003
Regards

William



"Bill_S" wrote in message
...
I need to rank a number against a separate list. It appears that the RANK
function in Excel requires your value to actually be "in" the list you're
ranking it against. Is there a formula I could use to work around this
limitation of the built-in RANK function.