Ranking with criteria

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

Assuming that A1:B1 contain your headers (Unit and Value), and A2:B7
contains your data, try...

C2, copied down:

=SUMPRODUCT(--($A$2:$A$7=A2),--(B2<$B$2:$B$7))+1

Hope this helps!

In article <736A222E-5238-4A2D-B5D7-4F34F20C52B9@microsoft.com>,
"EstherJ" <EstherJ@discussions.microsoft.com> wrote:

> 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