W
whodey
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.
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.