I have a list which I would like to rank based on a criteria. I would like
the formula to look at all FCP Units and work out the ranking of the value
against all other FCP units. Below is an example of what I am trying to
achieve.

Unit Value Rank
FCP 8700 1
MSS 6500 1
FCP 6477 2
MSS 571 2
MSS 569 3
FCP 512 3


Thanks,

Esther