Enter in F11:
=RANK(G4,G$4:G$6,1)

and fill down to F13

Regards,
Stefi

€žwhodey€� ezt Ã*rta:


Here's my problem....I want to assign values to a formulas outcome to be
ranked in ascending or descending values. For instance:

Cell F4= 5000
Cell G4= F4/365 (formula outcome= 13.698)

Cell F5= 20000
Cell G5= F5/365 (formula outcome= 54.795)

Cell F6= 7000
Cell G6= F6/365 (formula outcome= 19.178)

etc, etc, etc....

Is there a way I can program Excel to assign 1 to the cell F5 series, 2
to the cell F6 series, and 3 to the cell F4 series such that cells F11
through 13 would show 1, 3, and 2 based on the rankings of the G
columns outcome?

If that doesn't make sense let me know...thanks in advance for any help
that can be provided.


--
whodey
------------------------------------------------------------------------
whodey's Profile: http://www.excelforum.com/member.php...o&userid=29596
View this thread: http://www.excelforum.com/showthread...hreadid=492977