Multiple duplicate entries, multiple rankings

[oO P2K Oo]

Hi All,

Thanks for taking the time to view my post.

I have around 2000 lines of data, and a small sample is shown below.

Product code	Value
I300616729-43376	6
I300616729-43376	2
I300616729-43474	2
I300616729-43474	5
I300616729-43482	5
I300616729-43482	6
I300682288-43199	6
I300682288-43199	1

<tbody>
</tbody>

I would like to rank the value of the product code, but instead of having a rank of 1-8, I want to rank them between themselves, based on the value, so the lower the value (closer to 1), then the higher the ranking . e.g. below

Product code	Value	Rank
I300616729-43376	6	2
I300616729-43376	2	1
I300616729-43474	2	1
I300616729-43474	5	2
I300616729-43482	5	1
I300616729-43482	6	2
I300682288-43199	6	2
I300682288-43199	1	1

<tbody>
</tbody>

Many thanks in advance for your suggestions and solutions. If you require any more info, please do not hesitate to ask.

 

[steve the fish]

How about:

=SUMPRODUCT(--(A2=$A$2:$A$10),--(B2>$B$2:$B$10))+1

 

[oO P2K Oo]

Thank you steve, this worked wonderfully!

Have a great weekend!