Actually, my thinking differed from your premise. I assumed, maybe
incorrectly, that if the lowest number is 10, you want to rank 9, and
you only have 28 cells, 9 would be ranked 29th.

Hmmm...interesting! :)

In article ,
"RagDyeR" wrote:

If you're ranking 28 cells, the highest rank is 1, and the lowest rank is
28.

If the highest number is 100, and you want to rank 500 somewhere within the
28 cells, the rank is *still* 1.

Conversely, if the lowest number is 10, and you want to rank 9, you only
have 28 "rankings", so 9 would also be ranked 28th ... no? ... meaning the
lowest rank possible, since this *WORLD* only exists between 1 and 28 !

If that premise is acceptable, then try this *array* formula:

=RANK(MAX(IF(A1:A28<=C1,A1:A28),MIN(A1:A28)),A1:A2 8)

Array formulas are entered using CSE, <Ctrl <Shift <Enter, instead of the
regular <Enter, which will *automatically* enclose the formula in curly
brackets, which *cannot* be done manually.

--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------